date entered display
 

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.

date entered display
 

=--(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.

date entered display
 

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.

date entered display
 

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.

date entered display
 

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.

date entered display
 

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.

date entered display
 

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.

date entered display
 

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.