| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Thank you
"roly" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
