Page 1 of 1

in millions

Posted: Wed Aug 23, 2017 6:21 pm
by laducd
I have a file in millions. Client wants to see the values in millions. Basically 5,500,000 will by be 5.5.

Is there a quick way to do that? I'm not sure if I just have to add divide by a million in my formulas

Re: in millions

Posted: Thu Aug 24, 2017 1:04 am
by Edward
Hi Laducd,

As an alternative way of formatting the value you also could use the following expression:

Code: Select all

{5000000.ToString("#,##0,,M")}
Thank you
Edward