| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you delete leading zeros from numbers?
I want to see .5 not 0.5
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I enter NUMBERS with leading zeros In Excel ie 001, 002 ? | Excel Discussion (Misc queries) | |||
| Removing leading zeros from a group of numbers | Excel Discussion (Misc queries) | |||
| Delete leading zeros | Excel Discussion (Misc queries) | |||
| Social Security Numbers & Leading Zeros | Excel Discussion (Misc queries) | |||
| sort numbers leading zeros | Excel Discussion (Misc queries) | |||
Linear Mode
