Results 1 to 2 of 2

Thread: Special Currency Format

  1. #1
    Seeker SoudeDia's Avatar
    Join Date
    Aug 2013
    Location
    Tampa Bay, FL
    Posts
    9
    Articles
    0
    Excel Version
    16, 365

    Special Currency Format



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Our company has a unique currency reporting format. Thousands are "M", Millions are "MM". I have crafted the format with one small issue. The negative currency does not do the "MM", only "M". Can anyone help me fix this formula? Oh, negatives should also be red and in parenthesis. Currency: [>=1000000] $#,##0.0,," MM";[>0] $#,##0.0," M";[Red]($#,###," M").

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,807
    Articles
    0
    Excel Version
    O365
    I have never got a format to do all of what you ask, so I tend to revert to event code to test the value and set the format accordingly.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •