Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Column in CSV file contains "03/04" should not display as 3-Apr -.
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. |
#2
|
|||
|
|||
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 wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File asks to update when no links were created | Links and Linking in Excel | |||
How do I multiply Column G Totals by a number and display the res. | Excel Discussion (Misc queries) | |||
format question when open csv file | Excel Discussion (Misc queries) | |||
Conditional display of a .jpeg file? | Excel Discussion (Misc queries) | |||
Convert text file to MS_Excel | Excel Discussion (Misc queries) |