View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lalohg lalohg is offline
external usenet poster
 
Posts: 1
Default problems with dates before 1900

Hi there,
I have MS Office 2000 and have a question, I hope someone can help me.
I have a column with the date of birth formated as mm/dd/yyyy. M
problem is that some subjects were born before 1900 but instead o
getting mm/dd/yyyy I get yyyy/mm/dd and I can't change the format t
mm/dd/yyyy in those that were born before 1900. Does anyone know how
can change the EXCEL format so it accepts dates before 1900?

than

--
Message posted from http://www.ExcelForum.com