| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Entry in Excell
How do I enter numbers that start with zero i.e. 01-1-5121? Every time I
enter a number like the one previously noted, it changes. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Number Entry in Excell
Either pre-format the cell as TEXT, or type a leading apostrophe before the
first zero. The apostrophe will not show up in the cell but automatically formats that cell as TEXT. Vaya con Dios, Chuck, CABGx3 "viper2000ss" wrote: How do I enter numbers that start with zero i.e. 01-1-5121? Every time I enter a number like the one previously noted, it changes. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i save a 12 digit number in a .csv document in excell? | Excel Discussion (Misc queries) | |||
| Get the number of last row entry | Excel Discussion (Misc queries) | |||
| Excell deletes 0 when its the first number in a string | Excel Discussion (Misc queries) | |||
| How do I start an Excel entry with then number 0? | Excel Discussion (Misc queries) | |||
| Want a number of cells to be auto completed based on entry in one. | Excel Worksheet Functions | |||
Linear Mode
