| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
auto edit problem
Excel keeps automatically removing "0" from the front of a #, but I want to
keep them there |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
auto edit problem
When you enter a "number" string with leading zeros in a cell that's
formatted for a number, or general, Excel just deletes the leading zeros and converts the remaining digits to a number. If you want to retain the leading zeros in a string, either pre-format the cell for TEXT, or type an apostrophe before entering the string. Vaya con Dios, Chuck, CABGx3 "Julie" wrote: Excel keeps automatically removing "0" from the front of a #, but I want to keep them there |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data auto edit | Excel Discussion (Misc queries) | |||
| Excel edit problem, (of my own making!!) | Excel Discussion (Misc queries) | |||
| Edit-Find doesn' work, don't know the problem. | New Users to Excel | |||
| Edit-Find doesn' work, don't know the problem. | New Users to Excel | |||
| Edit Links - Combo Box Problem | Excel Worksheet Functions | |||
Linear Mode
