Date formatting inconsistent
I am trying to format a date such as 02-Aug-1963, however when I change the
year to 1863, the format switches to 8/2/1863. I've used Custom Formatting, but the problem persists. |
Date formatting inconsistent
Excel does not recognize dates before 1900 as dates
it sees your 8/2/1863 as text "Chuck" wrote: I am trying to format a date such as 02-Aug-1963, however when I change the year to 1863, the format switches to 8/2/1863. I've used Custom Formatting, but the problem persists. |
Date formatting inconsistent
OK. Thank you.
"bj" wrote: Excel does not recognize dates before 1900 as dates it sees your 8/2/1863 as text "Chuck" wrote: I am trying to format a date such as 02-Aug-1963, however when I change the year to 1863, the format switches to 8/2/1863. I've used Custom Formatting, but the problem persists. |
All times are GMT +1. The time now is 05:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com