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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()