Date Problem

N

Nick C

I have exported some data from an accounts package. When I export to a CSV
file I get the date in the correct format which is 20081130, when I export to
Excel however, whilst this is displayed correctly, when I click on the cell
it is shown as 30/11/2008.

Can anyone tell me how to display as text or a number. I have tried the
basics (format text/number etc.)

Thanks,

Nick
 
P

Pecoflyer

Nick said:
I have exported some data from an accounts package. When I export to
CSV
file I get the date in the correct format which is 20081130, when
export to
Excel however, whilst this is displayed correctly, when I click on th
cell
it is shown as 30/11/2008.

Can anyone tell me how to display as text or a number. I have trie
the
basics (format text/number etc.)

Thanks,

Nick
Click to expand...

In the import wizard, check delimited - Next - Next - Choose "text" i
the column data format - O

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste
 
N

Nick C

Thanks Pecoflyer,

Can you tell me where the import wizard is on office 2007 please.

Regards,

Nick
 
P

Pecoflyer

Nick said:
Thanks Pecoflyer,

Can you tell me where the import wizard is on office 2007 please.

Regards,

Nick
Click to expand...

If you open your CSV file in XL with File - Open you are presented wit
the import wizar

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste
 
G

Gord Dibben

Not in any version of Excel I have used.

*.txt files will trigger the Text Import Wizard.

*.csv do not.

General suggestion is to change the file extension from csv to txt then
open.


Gord Dibben MS Excel MVP
 
Top