Date problems

[Gerry]

I am using dates with the format .... yyyy/mm/dd in a Genealogy worksheet.

When I input dates in the 1900 range I get all sorts of problems ....

showing as ########### because they do not fit into the column width as 1899
does. When I widen the column the 1900 date offsets two spaces to the right.
I hcan make it look right by playing with the width of the column.

Sorting the column of dates puts the 1900 dates in various orders - top
middle and bottom.

Any ideas?

Where can I access Excel FAQ's.

Thanks

Gerry

 

[Niek Otten]

Hi Gerry,

Please don't multi-post

See my answer in other newsgroup

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am using dates with the format .... yyyy/mm/dd in a Genealogy worksheet.
|
| When I input dates in the 1900 range I get all sorts of problems ....
|
| showing as ########### because they do not fit into the column width as 1899
| does. When I widen the column the 1900 date offsets two spaces to the right.
| I hcan make it look right by playing with the width of the column.
|
| Sorting the column of dates puts the 1900 dates in various orders - top
| middle and bottom.
|
| Any ideas?
|
| Where can I access Excel FAQ's.
|
| Thanks
|
| Gerry
|
|