Hi Helpless,
You can just type in 2/1/4 and Excel will autocorrect to 02/01/04
anyway, which is marginally quicker than typing 020104.
You could also use the LEFT, MID, RIGHT and CONCATENATE functions to do
this aswell:
=LEFT(A1,2)&"/"&MID(A1,3,2)&"/"&RIGHT(A1,2)
This will only be recognised in another cell.
All the best,
Roly
--
roly
------------------------------------------------------------------------
roly's Profile:
http://www.excelforum.com/member.php...o&userid=24631
View this thread:
http://www.excelforum.com/showthread...hreadid=401727