B
bequa
I would like to type in my date with out using the /
Can I do that?
Can I do that?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Tonto
bequa said: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
P
PCLIVE
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
Format Cells. Under the Number tab choose Custom. You type in the format
you want.
mmddyyyy
R
Ron Rosenfeld
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
P
PCLIVE
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
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
R
Ron Rosenfeld
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