date entered display

K

Kate

If I enter the date of 10/25/06 as 102506, I would like it to display as
10/25/06. What formla do I use. I have the column formatted as SHORT DATE
and it shows up as 8/24/2180.
 
F

Farhad

Hi,

You have to use a helper column like below:

A B
1 102506 =LEFT(A1,2)&"/"&MID(A1,3,2)&"/"&RIGHT(A1,2)

and copy drag down the formula to where ever you need

Thanks,
 
K

Kate

This formula did work. But when I enter 102506, it shows up as 102506 and I
wanted it to display as 10/25/06
 
Top