Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |