in millions

[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

[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