How do I convert dates stored as dates to text?
(In xl2000+) try copy and pasting the date range as formatted text:
1. Press Ctrl+C twice, format number as text and click the paste icon.
2. Then undo and paste special as text [only for small ranges <2k].
"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?
|