View Single Post
  #1   Report Post  
mikelenno
 
Posts: n/a
Default How do I convert date values to non-date format e.g. 01-06-78?

Hello,

we have a large spreadsheet (Excel 2003) with bank codes that have been
automatically converted to date format. Any bank code in column G that could
also be a date, such as 03-07-78, will get converted to 03/07/78. Is there a
way to convert these 'dates' back to format for bank code (we do need date
format for other column)?

Thank you,