numbers and text in Excel to read as text keeping the leading zer.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
Raouf
 
I don't know on the actual importation. But, you could
easily:

A B C
1 Number 00 =B2 & A1

Drag down Row C.
Then Select all row C, then copy, paste special, values.
Done.
 
Raname it to txt and open it with the text import wizard, click next twice
and in step 3 under column data format select text for this particular column

Regards,

Peo Sjoblom
 
Back
Top