Convert Date to Text
 

Is there an easy was to convert date field to text without it converting to a
serial number. Right now I take the date field, convert text to column, add
the two columns with a / then concatenate the five columns, then copy paste
special with values only.

Seems like a long process for simple text. Any suggestions?

Convert Date to Text
 

If you are starting with an Excel date, them merely =TEXT(A2,"dd mmm yyyy"),
adjusting the formatting characters to suit your preference.
--
David Biddulph

"char needs text" <char needs wrote in
message ...
Is there an easy was to convert date field to text without it converting
to a
serial number. Right now I take the date field, convert text to column,
add
the two columns with a / then concatenate the five columns, then copy
paste
special with values only.

Seems like a long process for simple text. Any suggestions?

Convert Date to Text
 

Try =TEXT(A1,"dddd mmmm yyyy")

Where A1 has the data info. You can change the display format, such
as dd/mm/yy or whatever you want.