EXCEL DROPS OFF ALL ZEROS PRECEEDING A NUMBER
 

EXCEL DROPS OFF ALL ZEROS PRECEEDING A NUMBER

EXCEL DROPS OFF ALL ZEROS PRECEEDING A NUMBER
 

If you really need the zeroes you can start with ' which formats cell as
text. eg '00002

"ARTHURG" wrote:

EXCEL DROPS OFF ALL ZEROS PRECEEDING A NUMBER

EXCEL DROPS OFF ALL ZEROS PRECEEDING A NUMBER
 

"ARTHURG" wrote:
EXCEL DROPS OFF ALL ZEROS PRECEEDING A NUMBER

Ok, so we know you're annoyed (pl refrain from posting in all caps). Try
pre-formatting the entire col as Text (via clicking Format Cells Text
OK), then enter your data. Alternatively, precede the data entry with an
apostrophe/single quote (the apostrophe won't show when you press ENTER).
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

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