text to excel conversion

[aditya_5]

hi,
I think, my problem is not answered exactly.
My problem is whatever the data is present in .csv format is not being displayed in excel
on opening the file in excel.

I may have the no's of any sort i.e a no can be 01, 001 or anything....but whatever be the no....it must be displaed as the same no....as in .csv format.

Hope i get a good sol for this problem.
-adi

[Patrick Wallek · Accepted solution]

OK, I think I've found a way for you to get what you want.

Note: I am using MS Excel 2002

1) Go to DATA menu, select Import External Data and Import Data.

2) Select your CSV file that you want to import. This should bring up the "Text import Wizard"

3) Select "Delimited" from the file type and click "Next"

4) Deselect "Tab" as the delimiting character and Select "Comma" as the delimiting character and then click "Next"

5) In the "Data Preview" window single-click in the first column, scroll all the way right to the last column and hold down the SHIFT key and single-click on the last column to select all columns (or all columns that are the 001 numbers). Now go up to the "Column Data Format" area and select "Text" and now click on "Finish".

This will import all of your data into Excel with one number per column and all the numbers with leading 0's should display with the leading 0's intact.

I think this will give you what you want.

[Nic Harvard]

Further to Paul's reply:
If this is an ongoing this, create a macro to do do it for you.
If you're not up on macro's use a low-tech solution - click on "record macro", do the entire function as paul described, and save this macro for use later.
:)