View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default How do I convert dates stored as dates to text?


Use the following formula, changing the cell address and date format

=TEXT(A1,"dddd, mmmm d, yyyy")

A1 is the cell with the date
"dddd, mmmm d, yyyy" is the format mask that would produce Friday, September
7, 2007
--
Kevin Backmann


"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?