I also want it to effect every entry in that column.

"Farhad" wrote:

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,

--
Far4had Hodjat


"Kate" wrote:

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.