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