Seamus2626
asked on
Number format
Hi,
I have a number that displays as 40,556,062
When I add data points the graph shows 41, how can I custom format it so it shows $40.57 M
Currently the custom format is #,##0.00
Thanks!
I have a number that displays as 40,556,062
When I add data points the graph shows 41, how can I custom format it so it shows $40.57 M
Currently the custom format is #,##0.00
Thanks!
ASKER
Thanks Saurabh but that is returning 0.00 M
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect lads, thanks!
#,##0.00,, "M"
Saurabh...