i want to put my date in with no / exp: 02021951
 

I would like to type in my date with out using the /

Can I do that?

i want to put my date in with no / exp: 02021951
 

bequa wrote:

I would like to type in my date with out using the /

Can I do that?

Check out Chip Pearsons pages on times and dates.

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


Jp

i want to put my date in with no / exp: 02021951
 

you can use a custom format for the cell. Right=click the cell, select
Format Cells. Under the Number tab choose Custom. You type in the format
you want.

mmddyyyy

"bequa" wrote in message
...
I would like to type in my date with out using the /

Can I do that?

i want to put my date in with no / exp: 02021951
 

On Mon, 11 Sep 2006 17:57:44 -0400, "PCLIVE" wrote:

you can use a custom format for the cell. Right=click the cell, select
Format Cells. Under the Number tab choose Custom. You type in the format
you want.

mmddyyyy


Interesting recommendation.

On my system, I formatted the cell as you recommended. I then entered the OP's
date 02021951.

The cell now shows: 11297435

I do not think that is the expected result. What is your explanation?
--ron

i want to put my date in with no / exp: 02021951
 

Sorry about that. I misread the post. If the date was currently showing
with slashes "/", then you could reformat it as I suggested. It does not
apply if you just want to type the numbers without slashes. However, you
could use a customer format of"

00000000

That should keep the typed number unchanged and force preceeding zeros to be
maintained.

HTH,
Paul

"Ron Rosenfeld" wrote in message
...
On Mon, 11 Sep 2006 17:57:44 -0400, "PCLIVE" wrote:

you can use a custom format for the cell. Right=click the cell, select
Format Cells. Under the Number tab choose Custom. You type in the format
you want.

mmddyyyy


Interesting recommendation.

On my system, I formatted the cell as you recommended. I then entered the
OP's
date 02021951.

The cell now shows: 11297435

I do not think that is the expected result. What is your explanation?
--ron

i want to put my date in with no / exp: 02021951
 

On Tue, 12 Sep 2006 09:47:33 -0400, "PCLIVE" wrote:

Sorry about that. I misread the post. If the date was currently showing
with slashes "/", then you could reformat it as I suggested. It does not
apply if you just want to type the numbers without slashes. However, you
could use a customer format of"

00000000

That should keep the typed number unchanged and force preceeding zeros to be
maintained.

HTH,
Paul


Yes, but Excel will not interpret that value as a date.

To allow both the entry method, and the date interpretation, the initial
recommendation to consult Chip's web site is probably the most relevant.

In general, you need a VBA event macro, or a helper column with the appropriate
formula, to convert the OP's desired data entry method into an Excel recognized
date.


--ron