View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Olly
 
Posts: n/a
Default Formating cells with date format

http://www.cpearson.com/excel/datetime.htm

"Alexandre Duarte" wrote in
message ...
Hi everyone.
I have a worksheet with two columns. The first with date and the other
with
text formated cells.
When I enter in the first one data with the year < 1900 the format never
assumes the right date format
Can anyone provide me with some explanation about this?
Regs
Alexandre Duarte