Date problems
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 |
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 | | |
All times are GMT +1. The time now is 05:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com