Date Problem

  • Thread starter Thread starter Nick C
  • Start date Start date
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
 
Thanks Pecoflyer,

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

Regards,

Nick
 
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
 
Back
Top