Excel 2000 date does not display date correctly

G

Guest

I want to enter birthdays into a cell. I use the "format
cell" for style 5/10/89 (for example). When I actually
enter the birth date in this fashion 52952 and press the
arrow/enter key I receive the following date: 12/21/44.

I thought when I formatted the cell with the date option,
I could enter the birth date in this fashion 52952 and the
slashes (/) would be entered automatically. How can I
resolve this odd date entry?
 
H

Harald Staff

No, sorry, you can't do that. Some kind of separators between days, months,
years is required. Excel has no way of interpreting an entry like
11111
(is it january 11th, january 1st, november 1st, ... and which year ? )

HTH.Best wishes Harald
 
W

William

The correct number to enter for the date October 5 1989 is 32786. Where do
you get the 52952 from?

--
XL2002
Regards

William

[email protected]

| I want to enter birthdays into a cell. I use the "format
| cell" for style 5/10/89 (for example). When I actually
| enter the birth date in this fashion 52952 and press the
| arrow/enter key I receive the following date: 12/21/44.
|
| I thought when I formatted the cell with the date option,
| I could enter the birth date in this fashion 52952 and the
| slashes (/) would be entered automatically. How can I
| resolve this odd date entry?
|
 
F

Fred Smith

52952 is actually May 29/52, which anonymous wants to enter as a date
without slashes.

The options are to write a macro, or to use a helper column with the
formula:

=date(mod(a1,100),int(a1/10000),mod(int(a1/100),100))
 
W

William

Hi anonymous

Apologies - I didn't pick that up from your original post although I did
following Harald's reply.

--
XL2002
Regards

William

[email protected]

| 52952 is actually May 29/52, which anonymous wants to enter as a date
| without slashes.
|
| The options are to write a macro, or to use a helper column with the
| formula:
|
| =date(mod(a1,100),int(a1/10000),mod(int(a1/100),100))
|
| --
| Regards,
| Fred
| Please reply to newsgroup, not e-mail
|
|
| | > The correct number to enter for the date October 5 1989 is 32786. Where
do
| > you get the 52952 from?
| >
| > --
| > XL2002
| > Regards
| >
| > William
| >
| > [email protected]
| >
| > | > | I want to enter birthdays into a cell. I use the "format
| > | cell" for style 5/10/89 (for example). When I actually
| > | enter the birth date in this fashion 52952 and press the
| > | arrow/enter key I receive the following date: 12/21/44.
| > |
| > | I thought when I formatted the cell with the date option,
| > | I could enter the birth date in this fashion 52952 and the
| > | slashes (/) would be entered automatically. How can I
| > | resolve this odd date entry?
| > |
| >
| >
|
|
 
Top