Supplemental info to "HELP-excel date malfunction

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lester Stiefel - 19 Dec 2007 20:33 GMT

Here's some additional info to the earlier post on the
date cell function malfunction. Been isolated to the
function to insert the date (cell format/date). It seems the
application cannot interpret the system date properly.
Always inserts/interprets the date as CurrentMonth-01-2011,
instead of actual date. I cannot use the application this
way. I am using the 'general' setting in cell format, then
entering the string Month(abr)-day [eg= dec-17] instead of
letting application enter the date automatically.
Is there a patch available for this issue?

Signature

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

Reply to this Message

David McRitchie - 30 Dec 2007 20:46 GMT

would suggest that you stick to your original thread.

> Here's some additional info to the earlier post on the
> date cell function malfunction. Been isolated to the
[quoted text clipped - 6 lines]
> letting application enter the date automatically.
> Is there a patch available for this issue?

Reply to this Message

Gord Dibben - 30 Dec 2007 21:31 GMT

Lester

I am confused by......... .."function to insert the date(cell format/date)"

There is no function to insert the date unless you mean CTRL + ;

And this....... "I am using the 'general' setting in cell format, then
entering the string Month(abr)-day [eg= dec-17] instead of
letting application enter the date automatically."

What do you mean by "enter the date automatically"

What date do you get when you enter 12/17 or 12/17/2007

Format>Cell>Number>Date does not "insert" a date, only formats what is in the
cell.

Gord Dibben MS Excel MVP

>would suggest that you stick to your original thread.
>
[quoted text clipped - 8 lines]
>> letting application enter the date automatically.
>> Is there a patch available for this issue?

Reply to this Message

Rate this thread: