View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Suresh
 
Posts: n/a
Default Date format conversion

Excel recognises dates beginning 1 January 1900 only. I dont know if there
are any codes available out there to make this work.

"Terry Pinnell" wrote:

How can I convert date entries like

Sep 1883 and Mar 1867 to dates that Excel will recognise please? At
present it's just treating them like alphanumeric strings.

--
Terry, West Sussex, UK