View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Desoto Desoto is offline
external usenet poster
 
Posts: 5
Default Cell Format Defaults to a Formula

I have inherited a worksheet constructed by someone else and need to load
dates in a column of cells. Unfortunately when a date of "3/17/2008" is
entered into the cell range it displays January 1, 1900. If the cell range
is formated to "Date Format" it continues to display January 1, 1900. Can
someone please tell me what I am missing here?

Thanks in advance?
Desoto