automatic formatting to date

[blom0344]

Is there a way to automatically convert input like 010203 to date format 1-2-2003.
If I try it in a date formatted cell the result is:
01/02/27 ?????????????? T. Blom
Information analyst
tbl@shimano-eu.com

 

[xlbo]

You can format it to LOOK like a date but there is no format to actually CONVERT the entry to a date. ie it'll look like a date but you won't be able to apply calculations to it like you would a date

To do this, use a CUSTOM format of
00"-"00"-"0000
To convert to a proper date, you need to use a formula like
=left(a1,2)&"/"&mid(A1,3,2)&"/"&right(A1,4) Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[PepeLeMokko]

When you input "010203" XL treats it like the number 10203 which reprsents a date in MS value ( in this case 01/02/27)
If you format your cell as f.i. mm-dd-yyyy and input "01/02/03" ( or 01-02-03) it will read as 01-02-2003