Thread: Unifying different date formats in a spreadsheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob W Bob W is offline
external usenet poster
  
Posts: 22
Default Unifying different date formats in a spreadsheet
I inherited a spreadsheet with 2,285 rows; each row has dates typed into
them, and the dates are in three random formats, ie,

5-Aug-05
12/27/97
3-12-04

Is there a way, other than manually, to correct all the dates to one uniform
date format?


Reply With QuoteReply With Quote