Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 10th 04, 06:49 PM
Ralph
 
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
Raouf


  #2   Report Post  
Old December 10th 04, 06:59 PM
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

.

  #3   Report Post  
Old December 10th 04, 07:05 PM
Peo Sjoblom
 
Posts: n/a
Default

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Paste rows of numbers from Word into single Excel cell BecG Excel Discussion (Misc queries) 1 December 8th 04 04:55 PM
convert excel list to pivot table GI Excel Discussion (Misc queries) 0 December 6th 04 06:45 PM
I enter numbers and they are stored as text burkeville Excel Discussion (Misc queries) 5 December 3rd 04 01:59 AM
Converting text to numbers Scott Excel Discussion (Misc queries) 3 November 26th 04 09:17 PM


All times are GMT +1. The time now is 02:23 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017