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

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

Depending on what exactlyyou need to do, another option would be to use the
TEXT function:

=TEXT(A1,"dd/mm/yyyy")

Regards,
KL


wrote in message
ups.com...
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

Thankyou to you both, So easy when you know how, I went with Gord
Dibben suggestion.
Regards Robert