Cell Format Defaults to a Formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Desoto - 18 Mar 2008 02:24 GMT

I have inherited a worksheet constructed by someone else and need to load
dates in a column of cells. Unfortunately when a date of "3/17/2008" is
entered into the cell range it displays January 1, 1900. If the cell range
is formated to "Date Format" it continues to display January 1, 1900. Can
someone please tell me what I am missing here?

Thanks in advance?
Desoto

Reply to this Message

Dave Peterson - 18 Mar 2008 02:29 GMT

In xl2003 menus, try:

Tools|Options|Transition tab
Uncheck all those Lotus 123 settings.

Excel is seeing your entry as
3 divided by 17 divided by 2008.

A very small number that would be on Jan 1, 1900 when you format it as a date.

> I have inherited a worksheet constructed by someone else and need to load
> dates in a column of cells. Unfortunately when a date of "3/17/2008" is
[quoted text clipped - 4 lines]
> Thanks in advance?
> Desoto

Signature

Dave Peterson

Reply to this Message

Desoto - 18 Mar 2008 03:22 GMT

Many thanks Dave. I will try that first thing in the morning when I get in
the office. I have worked with Excel for 15 years and had never come across
that issue.
Desoto

> In xl2003 menus, try:
>
[quoted text clipped - 14 lines]
> > Thanks in advance?
> > Desoto

Reply to this Message