decimal value leading zero's

[Bob]

Hi Group

How do I get excel to stop adding a leading zero to a
value like .567? I hate looking at 0.567!!! It just ruins
the visual effect!!!

These are calculated values formatted to 3 decimal places.
I have a stupid work around in which I use a helper cell
with the formula =TEXT(A1,".000"). I also tried things
like =LEFT(A1,4) but this doesn't work if the calculated
value is say 0.600 and the the added zero's are from
formatting. This will return .6 .

Isn't there a custom number format that could be used thus
eliminating any work around? I've searched the archives
but have not found a solution.

Thanks for any help or advice
Bob P.

 

[Dave R.]

You can try goto cell format and type (under Type) in something like:
#.#####

problem is that puts a "." after whole numbers, like 1 would be 1.

 

[Peo Sjoblom]

Try custom format and

..000

depending on how many decimals you want to show change the number of zeros
after the period
if you have .0 then 0.123 will show as .1 Note also that with integers you
will get trailing zeros

 

[Bob P.]

Dave, thanks for jogging my brain. I came up with a custom
format of ".000". This works just fine!

Bob P.

 

[Bob P.]

Thanks Peo. Daves suggestion "kicked" my brain into gear
and I did arrive at the format you suggest. Works just
fine!

Bob P.

 

[Dave R.]

Glad to be of assistance! I've never used a custom format before, thought
I'd give it a shot!