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.

=--(TEXT(A1,"00\/00\/00")) and format as date.
--
David Biddulph

"Kate" wrote in message
...
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.

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.

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



"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.

Kate

David has supplied a formula to be entered in a second cell.

If you don't want to deal with formulas you can use event code to change the
date as you type the 102506

See Chip Pearson's site for code.

http://www.cpearson.com/excel/DateTimeEntry.htm


Gord Dibben MS Excel MVP

On Wed, 11 Apr 2007 11:32:01 -0700, 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.

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.

Use the formula David gave you, then copy down the formula all along.
However if you want to enter these numbers and have them converted instantly
you need to use a macro


http://www.cpearson.com/excel/DateTimeEntry.htm




--
Regards,

Peo Sjoblom


"Kate" wrote in message
...
This formula did work. But when I enter 102506, it shows up as 102506 and
I
wanted it to display as 10/25/06



"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.

THANK YOU, THANK YOU. This code worked.



"Gord Dibben" wrote:

Kate

David has supplied a formula to be entered in a second cell.

If you don't want to deal with formulas you can use event code to change the
date as you type the 102506

See Chip Pearson's site for code.

http://www.cpearson.com/excel/DateTimeEntry.htm


Gord Dibben MS Excel MVP

On Wed, 11 Apr 2007 11:32:01 -0700, 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.