Column in CSV file contains "03/04" should not display as 3-Apr -.

G

Guest

I have a column in CSV data that contains "03/04" which is an Australian
financial posting year. Our finacial year is July 1st to June 30th. When I
open this CSV file with Excel it interprets this data as a date - 3rd April.
To make matters worse, it adds 2004 as a year, so changing the column to Text
gives me 38080 not 03/04. Is there a setting somewhere that can tell Excel
NOT to interpret data fields.
 
M

Myrna Larson

If you change the file extension to TXT, then when you open the file you'll
see the Text Import Wizard. It will let you specify that this column is text
rather than a date.

On Sun, 12 Dec 2004 19:17:02 -0800, "The Palewhale" <The
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I allow blank columns in a .CSV file? 8
The Search Key was not found in any record... 0
Fradulent Impersonator using my email addresses to post to news groups 6
Fradulent Impersonator using my email addresses to post to news groups 5
OpenOffice.Org Newsletter - Vol. 01 Issue 9 3

Top