How do I convert dates stored as dates to text?
=TEXT(A1,"mm/dd/yyyy")
Assuming you have a date in A1
You can then CopyPasteSpecialValue if you need to remove the formula...
"diamunds" wrote:
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?
|