I want a column to have data in any format, especially like
3/1/32
and leave it in that format i.e. NOT to try and convert it to a date

other rows are left untouched as they are obviously not dates e.g.
28/7/4/13

Both text and general format convert 3/1/32 to a long 11691

Is it possible to force this not to convert?


--
geoffwright
------------------------------------------------------------------------
geoffwright's Profile: http://www.excelforum.com/member.php...o&userid=31801
View this thread: http://www.excelforum.com/showthread...hreadid=515257