Question

Locked

Excell Date Formatting

By paulm ·
Hi Chaps and Chapettes

Here's one for you. Our Accounts girl is adamant she used to type dates into excel just as numbers and it would auto format the "/" in between. She tells me it no longer does it and therefore her computer has gremlins !!!

For example:-
For todays date, 24/01/2012, she would just type 240112 and it would automatically format to 24/01/2012.

I've tried to recreate and been through all the formating options I can find but cannot recreate it. I've never seen it but that's not to say it doesn't exist.

Anyone care to prove/disprove the theory?? And if so, I will gladly stand corrected but am struggling with this.

Many thanks
Paul .

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

excel 2007

by PurpleSkys Moderator In reply to Excell Date Formatting

right click cell, format cell, number tab, under catagory choose date, under type select date type there *3/14/2001 , that should so it; let us know if it doesn't

Collapse -

Reponse To Answer

by paulm In reply to excel 2007

Hey PurpleSkys
Thanks for your reply. Tried and failed. If I type 240112 as todays date, it comes back with 08/01/2530 which I believe is the serial date.
I've really never heard of a formatting option that puts in the "/" for you but she is VERY VERY ADAMANT so any further help would be greatly appreciated !!!

Or just tell me it can't be done

Collapse -

Reponse To Answer

by slueck In reply to excel 2007
Collapse -

what version

by PurpleSkys Moderator In reply to Excell Date Formatting

of office?

Collapse -

Try data to text

by louiecliu In reply to Excell Date Formatting

Look for Data | Text to Column or equivalent.

HTH
Louie

Collapse -

Mucho thankings

by paulm In reply to Excell Date Formatting

damn, she was right !!! Thanks for your help guys

Back to Software Forum
7 total posts (Page 1 of 1)  

Software Forums