Number Format: 1,000,000 = 1

[Kevin]

Hi

Is there a way I can format a number so that a value of 1,000,000 shows 1

thanks

 

[Lars-Åke Aspelin]

Hi

Is there a way I can format a number so that a value of 1,000,000 shows 1

thanks

Try the follwing format
"0 "
i.e. a zero followed by two spaces (but without the quote signs).

The help function actually states that
"#,,"
(but without the quote signs) should do the trick, but it did not work
for me.

Hope this helps / Lars-Åke

 

[Dave Peterson]

You could try a custom format of:

#,,

Hi

Is there a way I can format a number so that a value of 1,000,000 shows 1

thanks

 

[Shane Devenshire]

Hi,

Either
#,,
or
0,,

will work. You might also consider

#,,"M" or 0,,"M"
or
#,,KK or 0,,KK

If this helps, please click the Yes button

Cheers,
Shane Devenshire

 

[Lars-Åke Aspelin]

Try the follwing format
"0 "
i.e. a zero followed by two spaces (but without the quote signs).

The help function actually states that
"#,,"
(but without the quote signs) should do the trick, but it did not work
for me.

Hope this helps / Lars-Åke

The reason why 0,, did not work for me was that I don't use , (comma)
as the "digit grouping symbol", I use blank for that.

So the answer to your question could be rephrased like:

use a custom number format like a 0 followed by two occurances of the
digit grouping symbol that you use. And that seems to be , (comma)
from your orignal post.

/ Lars-Åke