close
I view and upload text files with a column of values that contain leading
zeros. I want to retain the leading zeros when I use Excel to view or store
this data. Any suggestions on how to turn off, Excel's elimination of the
leading zeros?
quot;mc01234quot; gt; wrote in message
news
gt;I view and upload text files with a column of values that contain leading
gt; zeros. I want to retain the leading zeros when I use Excel to view or
gt; store
gt; this data. Any suggestions on how to turn off, Excel's elimination of the
gt; leading zeros?
Format the cells as text.
--
David Biddulph
全站熱搜