Brother,

I think only a macro could convert your date to text. Perhaps if you tell
us why you need it in actual text, there are other solutions.

Perhaps

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"BrotherNov" wrote in message
...
I need to convert several columns of dates in excel to text. When I
simply
use the format cells command to reformat the cells to text, it first
converts
the date back to the underlying number then converts it to text. Hope I'm
being clear here.

Example - the date as viewed on the screen is Mon (Monday). When I
convert
it to text I get 38446. I want "Mon", in text format. Thanks!