| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL DROPS OFF ALL ZEROS PRECEEDING A NUMBER
Yes it does. Do you have a question?
You can specify a number of digits with a custom number format, you can format the cell as Text prior to entering the data, or you can precede the data with an apostrophe ('). And turn off your !#!$(!## CAPS LOCK. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "ARTHURG" wrote in message ... EXCEL DROPS OFF ALL ZEROS PRECEEDING A NUMBER |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel default number format problem | Excel Discussion (Misc queries) | |||
| The number in this cell is formatted as text or preceded by an apostrophe" problem in Excel | Excel Discussion (Misc queries) | |||
| Access Excel Linked Text and Number Issues | Excel Discussion (Misc queries) | |||
| Spliting a number with leading zeros | Excel Discussion (Misc queries) | |||
| Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Hybrid Mode
