How do I convert dates stored as dates to text?
=TEXT(A1,"mm/dd/yy")
replace the date format (US in my example) to whatever date format you are
using
--
Regards,
Peo Sjoblom
"diamunds" wrote in message
...
So basically... I have some dates stored as dates in Excel that I want to
convert to text without getting wacky numbers (i.e. I still want them to
display as the date, just categorized as text) any ideas?
|