excel puts in date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Moonraker - 19 Feb 2005 18:53 GMT

I have created 14 sheets with different titles all created independently, on
one of them I put in the date in A2, in B2 I put in number "1" and it
entered ok, in C2 I put "3" and it entered ok, in D2 I put in 1.75 and it
entered as JAN 05.

It only happened on the one sheet, as we tried it on two of the other
sheets, why might this be.

Cheers Steve

Reply to this Message

anonymous@discussions.microsoft.com - 21 Feb 2005 14:38 GMT

hi,
did you chech the cell format. when i formated a cell to
mm-yy and typed in 1.75, i got jan-00. not sure why it
didn't come out jan 05 but my first suspicions was to
check the formating.

>-----Original Message-----
>I have created 14 sheets with different titles all created independently, on
[quoted text clipped - 8 lines]
>
>.

Reply to this Message