View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Lori Lori is offline
external usenet poster
 
Posts: 272
Default 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?