Excel Help ASAP - New PC at Work [Closed]

Report
Posts
2
Registration date
Thursday August 2, 2012
Status
Member
Last seen
August 2, 2012
-
Posts
2
Registration date
Thursday August 2, 2012
Status
Member
Last seen
August 2, 2012
-
Hello,



Hi there, I jsut got a new PC at work and although I have my date coloumns formatted to dd-mmm-yy, when I try to key 7-31, instead the result is 00-Jul-31. I cannot for the life of me figure out how to change this back so my result is 31-Jul-12.

Thanks very much

1 reply

Posts
2
Registration date
Thursday August 2, 2012
Status
Member
Last seen
August 2, 2012

I would like to be able to key my dates month first then day, why isn't it working that way anymore?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!