Format numerical value to Million

[Orchid]

Hi,
I try to format a numerical value in Million. But I don't want to use
the number to divide by 1,000,000. Is there any way which I can just
use a format function? (i.e.: 12,666,678 ----> 12,7)
Your help is greatly appreciated! Thanks in advance!

 

[Ron Rosenfeld]

Hi,
I try to format a numerical value in Million. But I don't want to use
the number to divide by 1,000,000. Is there any way which I can just
use a format function? (i.e.: 12,666,678 ----> 12,7)
Your help is greatly appreciated! Thanks in advance!

You can't get quite what you've written, but you can get 12.7 (where "." is
the decimal symbol) using the format:

#0.0,,

If you want to add and M to the end, then use:

#0.0,,\M

--ron

 

[Orchid]

You can't get quite what you've written, but you can get 12.7  (where ".." is
the decimal symbol) using the format:

#0.0,,

If you want to add and M to the end, then use:

#0.0,,\M

--ron

Thanks so much for your help!! It works perfect as I want.

 

[Ron Rosenfeld]

Thanks so much for your help!! It works perfect as I want.

You're welcome. Glad to help. Thanks for the feedback.
--ron

 

[Shane Devenshire]

Hi,

Actually, you can get just what you want -

#","#,,\M

Cheers,
Shane

 

[Ron Rosenfeld]

Hi,

Actually, you can get just what you want -

#","#,,\M

Cheers,
Shane

Hmmm. When I try that on 1,234,567 I get ,1M and not 1,2M

--ron