| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do i get excel to NOT take zero's of the front of a number
|
|
#2
|
|||
|
|||
|
Use a custom format of say 000000
-- HTH RP (remove nothere from the email address if mailing direct) "tor" wrote in message ... |
|
#3
|
|||
|
|||
|
Try using an apostrophe before you enter your number. HTH Cindy
"tor" wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| In Excel how can i enter in a value like 0021 without the zeros . | Excel Discussion (Misc queries) | |||
| Displaying leading zeros in an Excel spreadsheet | Excel Discussion (Misc queries) | |||
| How do I stop excel removing zeros? | Excel Discussion (Misc queries) | |||
| excel front end to access | Excel Discussion (Misc queries) | |||
Linear Mode
