| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inconsistent Sorting | Excel Discussion (Misc queries) | |||
| Inconsistent CSV export format | Excel Discussion (Misc queries) | |||
| 3-d referencing inconsistent | Excel Discussion (Misc queries) | |||
| Inconsistent 'auto-entry' | Excel Discussion (Misc queries) | |||
| Inconsistent Chart Sizing Into PPT | Charts and Charting in Excel | |||
Linear Mode
