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