Thread: Date Format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NotGood@All NotGood@All is offline
external usenet poster
  
Posts: 14
Default Date Format
I have inherited a workbook that has some columns where the person entered
the date as 5/21, 6/10. All the dates are 2007. Is there a way for me to
add 2007 to each of the rows so the date appears as "5/21/2007"
--
NotGood@All
Reply With QuoteReply With Quote