Select the data range.

DataText to ColumnsNextNextColumn Data FormatTextFinish.


Gord Dibben Excel MVP

On 4 Sep 2005 10:25:49 -0700, wrote:

Hi, this is probably easy but I cant work it out. If I have 28/1/05 in
a cell, formated as dates, how can I retain the 28/1/05 when changing
to text format, at the momment it change to numbers (31...). Ive got
hundreds of dates to convert, I Know I can type ' infront of the date
and this works, but there must be a quicker way.
Regards Robert