You guys rock! Thanks! I had tried the text function, but wasn't using the
quote marks around the format. Thanks again!

"Earl Kiosterud" wrote:

Yup. To add to that, if that formula isn't supported by the Palm Handheld,
you could copy, then Paste special - Values right over the original stuff
(or elsewhere).

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

"Fred Smith" wrote in message
...
You can convert any number to text using the Text function. In your case,
use:

=Text(a1,"ddd")

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"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!