Questions

Excell Date Formatting

+
0 Votes
Locked

Excell Date Formatting

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 .
+
0 Votes
PurpleSkys Moderator

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

+
0 Votes
paulm

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

+
0 Votes
PurpleSkys Moderator

of office?

+
0 Votes
louiecliu

Look for Data | Text to Column or equivalent.

HTH
Louie

+
0 Votes
paulm

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