Date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

UBoat - 22 Feb 2006 19:07 GMT

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.

Reply to this Message

Gary''s Student - 23 Feb 2006 10:29 GMT

1. clear the cell of all contents
2. format the cell as general
3. enter 38763
4 format the cell as date

Signature

Gary's Student

> 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.

Reply to this Message