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