Thread: How do I change a date fro 22 sept 09 to September 22, 2009
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
joeu2004 joeu2004 is offline
external usenet poster
  
Posts: 2,059
Default How do I change a date fro 22 sept 09 to September 22, 2009

"Sister Agnes Mary" <Sister Agnes wrote in
message ...
Subject: How do I change a date fro 22 sept 09 to September 22, 2009

If the cell is formatted with a date format, not Text, simply change the
format to one that you like. In Excel 2003, right-click on the cell, click
on Format Cells and Number, select Date and scroll the list until you find
"March 14, 2001".

PS: For future postings, please repeat or expand on your question in the
body of the message, not just the subject line.

Reply With QuoteReply With Quote