View Single Post
  #1   Report Post  
Old December 10th 04, 06:49 PM
Posts: n/a
Default numbers and text in Excel to read as text keeping the leading zer.

I am trying to open a CSV file, one column is String but contains numerics
with leading Zero (ex. "00123456"). When I open it in Excel it looses the
leading Zeros, how can I keep it ON. I tried to pass the apostrophie ' , but
this did not help my problem as it still shows in the cell untill I Edit the
cell and re-enter it.

Thank you