Date Problem
 

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

Date Problem
 

Nick C;254719 Wrote:
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

In the import wizard, check delimited - Next - Next - Choose "text" in
the column data format - OK


--
Pecoflyer

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

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=71110

Date Problem
 

Thanks Pecoflyer,

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

Regards,

Nick

"Pecoflyer" wrote:


Nick C;254719 Wrote:
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

In the import wizard, check delimited - Next - Next - Choose "text" in
the column data format - OK


--
Pecoflyer

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

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=71110

Date Problem
 

Nick C;254734 Wrote:
Thanks Pecoflyer,

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

Regards,

Nick

"Pecoflyer" wrote:


Nick C;254719 Wrote:
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

In the import wizard, check delimited - Next - Next - Choose "text"
in
the column data format - OK


--
Pecoflyer

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

*Adding your XL version* to your post helps finding solution faster

------------------------------------------------------------------------
Pecoflyer's Profile: 'The Code Cage Forums - View Profile: Pecoflyer'
(http://www.thecodecage.com/forumz/me...pecoflyer.html)
View this thread: 'Date Problem - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...ad.php?t=71110)



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


--
Pecoflyer

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

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=71110

Date Problem
 

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

On Wed, 4 Mar 2009 10:17:15 +0000, Pecoflyer
wrote:

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


--
Pecoflyer