Display Leading Zeros

[Doug]

You might need to use Text Format OR not use text format
and use another column and use something like: for
example 0000304 comes in as 304 in cell C12. Then in B12 I
would put:
=REPT("0",7-LEN(VALUE(C12)))&VALUE(C12)

And then Copy / Paste Special / Values

-----Original Message-----
How do I keep Excel from truncating leading zeros in

cells? For example how do I keep 0000304 from becoming 304?

 

[Judy Freed]

You can also format the cell that contains the data with zero padding.
http://www.uncc.edu/sysdev/howtos/excel/zero padding numeric strings.htm

 

[Doug]

Very nice. And a very nice website also. Thanks.

 

[ptaparia]

Simply put a single quote ( ' ) at the start of the data in excel. fo
eg: you might want to enter '0000304 for excel to enter data 0000304

ptapari