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

[Guest]

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

RB

 

[Nick Hodge]

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
(e-mail address removed)
www.nickhodge.co.uk

 

[Guest]

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]

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
(e-mail address removed)
www.nickhodge.co.uk