Supplemental info to "HELP-excel date malfunction

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

Lester Stiefel

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




Lester Stiefel said:
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?
Click to expand...
Click to expand...
 
Back
Top