Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I insert a row into my spreadsheet that already contains a column of dates
(02/15/2006) the new cell does not return the correct date. What I get is
(fx=02/15/2006) in the cell and the displayed result is 1/0/1900. I have
tired setting the column format to display dates mm/dd/yy and mm/dd/yyyy and
the new cell still returns the incorrect value. All the other dates in the
column are correct.
 
1. clear the cell of all contents
2. format the cell as general
3. enter 38763
4 format the cell as date
 
Back
Top