Software

Ask something
Question Locked

Excell Date Formatting

0 helpful
7 replies

by tallpaul003

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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 .

7 replies

by purpleskys

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

by tallpaul003

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 ;)

by louiecliu

Look for Data | Text to Column or equivalent.

HTH
Louie

This discussion is closed to new replies.