Results 1 to 2 of 2

Thread: Special Currency Format

  1. #1

    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
    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