Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Zeros
I need to place a Zero in front of a number, but when i press enter, it goes
away, how can i keep it there????? |
#2
|
|||
|
|||
Precede your number with a single quote...
'055 ....or format your cell as 'Text'. Hope this helps! In article , Dena B wrote: I need to place a Zero in front of a number, but when i press enter, it goes away, how can i keep it there????? |
#3
|
|||
|
|||
Or if you truly need a "real" number,
Custom format to the number of digits you'll need. 00000 or 0000 or whatever. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Domenic" wrote in message ... Precede your number with a single quote... '055 ...or format your cell as 'Text'. Hope this helps! In article , Dena B wrote: I need to place a Zero in front of a number, but when i press enter, it goes away, how can i keep it there????? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating formulas that allow the solutions to start with zeros. | Excel Discussion (Misc queries) | |||
How do I force leading zeros in an Excel cell? | Excel Discussion (Misc queries) | |||
Leading zeros | Excel Discussion (Misc queries) | |||
replacing only zeros | New Users to Excel | |||
Excel file saved as csv - dropping zeros | Excel Discussion (Misc queries) |