Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I start an Excel entry with then number 0?
How do I start an Excel cell entry with the number 0? (i.e. a pin number or
zip code). Every time I enter it, then move out of the cell, the computer automatically removes the 0 in front of the remaining numbers. |
#2
|
|||
|
|||
format the cells text to begin with, or put a single quote ' in front of the
zero |
#3
|
|||
|
|||
before entering data go to Format-Cells-Text
This will now allow you to enter the data with 0 prefixed to a number OR Enter ' before your number "cajundoc" wrote in message ... How do I start an Excel cell entry with the number 0? (i.e. a pin number or zip code). Every time I enter it, then move out of the cell, the computer automatically removes the 0 in front of the remaining numbers. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Where is DateDiff function in Excel 2002 ? | Excel Worksheet Functions | |||
In Excel how can a number automatically display in text form | Excel Worksheet Functions | |||
how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) | |||
How do I set up a field in an Excel form to number it incremental. | Excel Worksheet Functions |