topic Re: text to excel conversion in BackOffice Products

text to excel conversion

aditya_5 — Sun, 30 Jun 2002 00:04:17 GMT

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

Re: text to excel conversion

Patrick Wallek — Sun, 30 Jun 2002 00:44:52 GMT

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.

Re: text to excel conversion

Nic Harvard — Wed, 03 Jul 2002 14:30:34 GMT

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.
:)