when loading csv file to Excel, cells get converted to date format
 

when loading csv file to Excel 2002, some numeric cells get converted to a
date format of type DD-MMM.

RB

when loading csv file to Excel, cells get converted to date format
 

RB

This is Excel's auto-recognition 'feature'. So I suspect you have part
numbers or similar with a dash in. To overcome this rename the file to
either have a .txt extension, or none at all. This way, when using
file<open..., you will get the text import wizard and be able to mark this
column as text in the third step of the wizard

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"RB" wrote in message
...
when loading csv file to Excel 2002, some numeric cells get converted to a
date format of type DD-MMM.

RB

when loading csv file to Excel, cells get converted to date fo
 

Hi Nick,
Thank you for your prompt response.
One more question. I found <cr inside text cells. This causes a rwo to be
broken into multiple ones. Is there a way for the wizard to "skip" those
invalid <cr?
RB

"Nick Hodge" wrote:

RB

This is Excel's auto-recognition 'feature'. So I suspect you have part
numbers or similar with a dash in. To overcome this rename the file to
either have a .txt extension, or none at all. This way, when using
file<open..., you will get the text import wizard and be able to mark this
column as text in the third step of the wizard

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"RB" wrote in message
...
when loading csv file to Excel 2002, some numeric cells get converted to a
date format of type DD-MMM.

RB

when loading csv file to Excel, cells get converted to date fo
 

RB

No, you would either need to find replace in the original data or the same
in the destination

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"RB" wrote in message
...
Hi Nick,
Thank you for your prompt response.
One more question. I found <cr inside text cells. This causes a rwo to be
broken into multiple ones. Is there a way for the wizard to "skip" those
invalid <cr?
RB

"Nick Hodge" wrote:

RB

This is Excel's auto-recognition 'feature'. So I suspect you have part
numbers or similar with a dash in. To overcome this rename the file to
either have a .txt extension, or none at all. This way, when using
file<open..., you will get the text import wizard and be able to mark
this
column as text in the third step of the wizard

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"RB" wrote in message
...
when loading csv file to Excel 2002, some numeric cells get converted
to a
date format of type DD-MMM.

RB