Date problems
Hi Gerry,
Please don't multi-post
See my answer in other newsgroup
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Gerry" wrote in message ...
|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
|
|
|