Rounding off the number to the nearest million
Hi All,
I have numbers like $1000000, $12000000, $13989098 on my report.
Now the requirment is I want to see these numbers to be rounded off to the nearest million..
for example:
1) $1000000 should be shown as $1.00M
2) $12000000 should be shown as $12.00M
3) $13989098 should be shown as $13.98M
Please suggest me a way to get the above thing working.
Thanks in Advance..