| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
leading 0
Can someone tell me how I can get rid of the leading 0 in
a cell that should only show .30 instead of 0.30? Probably a simple thing - but I jut can't find the answer. thanks in advance for your help! Cindy |
|
#2
|
|||
|
|||
|
FormatCellsNumber TabCustom.
enter .00 and OK your way out. Gord Dibben Excel MVP On Sat, 12 Mar 2005 19:15:08 -0800, "cb" wrote: Can someone tell me how I can get rid of the leading 0 in a cell that should only show .30 instead of 0.30? Probably a simple thing - but I jut can't find the answer. thanks in advance for your help! Cindy |
|
#3
|
|||
|
|||
|
Thank you!!!
Cindy -----Original Message----- FormatCellsNumber TabCustom. enter .00 and OK your way out. Gord Dibben Excel MVP On Sat, 12 Mar 2005 19:15:08 -0800, "cb" wrote: Can someone tell me how I can get rid of the leading 0 in a cell that should only show .30 instead of 0.30? Probably a simple thing - but I jut can't find the answer. thanks in advance for your help! Cindy . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format a cell to keep leading zeros. | New Users to Excel | |||
| zero supress leading zeros when chg format from text to number | Excel Worksheet Functions | |||
| Leading zeros | Excel Discussion (Misc queries) | |||
| CSV leading zeroes | Excel Discussion (Misc queries) | |||
| numbers and text in Excel to read as text keeping the leading zer. | Excel Discussion (Misc queries) | |||
Hybrid Mode
