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

R

RB

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

RB
 
N

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
[email protected]
www.nickhodge.co.uk
 
R

RB

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
 
Top