View Single Post
  #2   Report Post  
Brian
 
Posts: n/a
Default

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.

-----Original Message-----
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

.