Is there a formula to show $5,000,000 as $5M?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am looking for an easy way to convert $M values to eliminate the 6 zeros.

Thanks.
 
You could try something like this:
=IF(RIGHT(A1,6)="000000",A1/1000000&"M",A1)

unless someone has a better idea....

Sheila
 
Another option:
=TEXT(A1,"$ #,, ""M""")

Another option would be to keep the value in the cell, and use a similar
Custom format.
 
Another option:
=TEXT(A1,"$ #,, ""M""")

Another option would be to keep the value in the cell, and use a similar
Custom format.
Click to expand...
Custom format
$ 0,,\M
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Weighted Average Life 1
Nested If statement -- please help :) 8
Concatenating Currency and Percent 5
IF Question 3
Nested Formula Help 6
two-variable data table question 7
Program Column B to record numerical range based on number in colm 2
Formula to bring up to # but not over 3

Back
Top