How do you delete leading zeros from numbers?
 

I want to see .5 not 0.5

How do you delete leading zeros from numbers?
 

Format via FormatCells...NumberCustom and enter .0;-.0;0

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"emronexcel" wrote in message
...
I want to see .5 not 0.5

How do you delete leading zeros from numbers?
 

Format, cells from the menu bar - number tab, custom category, change to .00
to always display decimal and two places without the leading zero.
HOWEVER, Excel adds a leading zero to decimal values because this is the
proper formatting for such numbers. That little decimal can be misconstrued
as an ink splotch if there is no zero in front to make it clear.

"emronexcel" wrote:

I want to see .5 not 0.5