View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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?