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

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

unable to enter date into cell which should be formatted for dates 1
date format displaying as number 2
Date Format Problem. 2
Excel is changing date format incorrectly 7
Strange Julian Date Phenomenon 9
Excel Macro to copy a row to another sheet based on date 0
Find a date in list less or equal than target date 4
Excel Problem 5

Top