Date enters wrong #'s

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frustrated_rich99 - 06 Dec 2006 23:56 GMT

Hi,
I'm trying to format a cell to enter the date i.e. 6/12/06 dd/mm/yy
but when I format it custom dd/mm/yy it shows up as 11/03/40?

-Rich

Reply to this Message

Rookie 1st class - 07 Dec 2006 02:23 GMT

Is the cell already populated? I'm thinking yes. The current entry is not a
date, Try retyping after format. There is a date format like you want, no
need to custom format.
Lou

> Hi,
> I'm trying to format a cell to enter the date i.e. 6/12/06 dd/mm/yy
> but when I format it custom dd/mm/yy it shows up as 11/03/40?
>
> -Rich

Reply to this Message