Help - Date field not formatting properly

  • Thread starter Thread starter Lester Stiefel
  • Start date Start date
L

Lester Stiefel

An issue has come up in office 2003/excel. A date field
carried over from a spreadsheet written in Excel 97, cannot
format/read the date properly. The date is ok for the first
10 cells. After that, all are inserting 12-1-2011 instead of
the actual date. I have all of the dot net framework files
upgraded to date.

The problem is so serious that I'm considering migrating to
Open Office if there is no fix to the current problem.
PLEASE HELP!!
 
You say A1:A100 dates are OK but after that the only return is 12-1-2011

What does "carried over" mean? Copied? The 97 workbook was opened in 2003?

Does the 12-1-2011 return in all cells below A10 or is that just an example
date?

Are the dates off by 4 years and 1 day?

One of the workbooks could have Tools>Options>Calculation "1904 date system"
checked.


Gord Dibben MS Excel MVP
 
Gord said:
You say A1:A100 dates are OK but after that the only return is 12-1-2011

What does "carried over" mean? Copied? The 97 workbook was opened in 2003?

Does the 12-1-2011 return in all cells below A10 or is that just an example
date?

Are the dates off by 4 years and 1 day?

One of the workbooks could have Tools>Options>Calculation "1904 date system"
checked.


Gord Dibben MS Excel MVP
Click to expand...
Here is the exact problem. The date format box (cell
format, date) has options for all formats. The result for
the entry in each format string returns a sticky string of
"Current Month - Day - 2011". An example of this is
"12-1-2011" regardless of what date string is manually
entered. The intended output as seen by the format wizard is
seen in 'sample' is always "CurrentMonth-Day 1-2011". I feel
that option is damaged.

Right now I'm using OpenOffice 2.3.1, since the original
spreadsheet was written using that suite (Calc is an excel
clone for 1997). The date insert function in that is not
affected this way.
 
Lester,

Try exporting your spreadsheet to a .CSV file and then view it in a text
editor.

Do your dates export correctly?
 
Lester,

Try exporting your spreadsheet to a .CSVfileand then view it in a text
editor.

Do your dates export correctly?







- Show quoted text -
Click to expand...

Hi,

You may try a popular Excel file recovery tool called Advanced Excel
Repair to repair your Excel file. It is a powerful tool to repair
corrupt or damaged Excel files.

Detailed information about Advanced Excel Repair can be found at
http://www.datanumen.com/aer/

And you can also download a free demo version at http://www.datanumen.com/aer/aer.exe

Alan
 
You're not seriously suggesting that the workbook could be corrupted, are you?

I'm not sure how this kind of suggestion will get more people to try your
advertised program. I would expect this to cause more people to just ignore any
of your posts--including the threads where your program may actually be useful
(well, if it actually works!).
 
Alan,

Give it a rest. Not everything can be fixed by the utility that you so
liberally promote on almost every thread here. Your product isn't even
compatible with Office 2007. You should be banned from the discussion forum.
 
Back
Top