Display Leading Zeros

D

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
Click to expand...
cells? For example how do I keep 0000304 from becoming 304?
 
P

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
 
Top