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