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
 

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

Date Format Problem. 2
unable to enter date into cell which should be formatted for dates 1
date format displaying as number 2
Strange Julian Date Phenomenon 9
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
How to enter a date in DD-MM-YYYY format 2
Excel Automation from a Delphi 7 Program 0
Excel date format YYYYMMDD 1

Back
Top