ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   numbers and text in Excel to read as text keeping the leading zer. (https://www.excelbanter.com/excel-discussion-misc-queries/1684-numbers-text-excel-read-text-keeping-leading-zer.html)

Ralph December 10th 04 06:49 PM

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
Raouf


Brian December 10th 04 06:59 PM

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

.


Peo Sjoblom December 10th 04 07:05 PM

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

"Ralph" wrote:

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



All times are GMT +1. The time now is 10:23 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
ExcelBanter.com