Help - Date field not formatting properly

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lester Stiefel - 19 Dec 2007 18:47 GMT

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

Signature

Visit Family Radio Today
http://www.familyradio.com/

Reply to this Message

Gord Dibben - 19 Dec 2007 21:57 GMT

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

> An issue has come up in office 2003/excel. A date field
>carried over from a spreadsheet written in Excel 97, cannot
[quoted text clipped - 6 lines]
>Open Office if there is no fix to the current problem.
>PLEASE HELP!!

Reply to this Message

Lester Stiefel - 21 Dec 2007 07:25 GMT

> You say A1:A100 dates are OK but after that the only return is 12-1-2011
>
[quoted text clipped - 20 lines]
>> Open Office if there is no fix to the current problem.
>> PLEASE HELP!!

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.

Signature

Visit Family Radio Today
http://www.familyradio.com/

Reply to this Message

Gordon Bell - 18 Mar 2008 20:01 GMT

Lester,

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

Do your dates export correctly?

>> You say A1:A100 dates are OK but after that the only return is 12-1-2011
>>
[quoted text clipped - 33 lines]
> written using that suite (Calc is an excel clone for 1997). The date
> insert function in that is not affected this way.

Reply to this Message

Alan124 - 25 Mar 2008 15:18 GMT

> Lester,
>
[quoted text clipped - 42 lines]
>
> - Show quoted text -

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

Reply to this Message

Dave Peterson - 25 Mar 2008 16:15 GMT

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

> > Lester,
> >
[quoted text clipped - 55 lines]
>
> Alan

Signature

Dave Peterson

Reply to this Message

echeeseman - 27 Mar 2008 23:39 GMT

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.

> > Lester,
> >
[quoted text clipped - 55 lines]
>
> Alan

Reply to this Message

Rate this thread: