Display Leading Zeros

S

Steven

You have to make this a text format cell or put a ' in
front of the number. Also look at this function =Text
(ReferenceACellAddress,"#") and see the results.
Example in Cell A10 : =Text(B10,"#") if B10 has the
value you are using.
-----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?
 
Top