Number Format: 1,000,000 = 1

L

Lars-Åke Aspelin

Hi

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

thanks
Click to expand...


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
 
S

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
 
L

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
Click to expand...

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
 
Top