Hi

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

thanks
--
Kevin

On Sat, 29 Nov 2008 10:02:01 -0800, Kevin
wrote:

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

You could try a custom format of:

#,,



Kevin wrote:

Hi

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

thanks
--
Kevin

--

Dave Peterson

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
"Kevin" wrote:

Hi

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

thanks
--
Kevin

On Sat, 29 Nov 2008 18:21:16 GMT, Lars-Åke Aspelin
wrote:

On Sat, 29 Nov 2008 10:02:01 -0800, Kevin
wrote:

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

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