| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Formatting Error
A colleague of mine has a spreadsheet with various dates in them in the
format dd/mm/yyyy. Some of the dates where the day is less than 13 keep toggling between displaying dd/mm/yyyy and mm/dd/yyyy, however, if they are formatted as dd-mmm-yyyy they display the correct date and month. This only seems to happen on the pc at work and not at home which implies some configuration issue. I have seen this problem before myself but never got to the root cause, does anyone out there have a reason and hopefully a resolution to this issue? Thanks David |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Formatting Error
It's well worth looking at the Windows Regional Settings (in Control Panel).
-- David Biddulph "Cookie" wrote in message ... A colleague of mine has a spreadsheet with various dates in them in the format dd/mm/yyyy. Some of the dates where the day is less than 13 keep toggling between displaying dd/mm/yyyy and mm/dd/yyyy, however, if they are formatted as dd-mmm-yyyy they display the correct date and month. This only seems to happen on the pc at work and not at home which implies some configuration issue. I have seen this problem before myself but never got to the root cause, does anyone out there have a reason and hopefully a resolution to this issue? Thanks David |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Formatting Error
Hi,
Both pc's have the regional settings for the short date set to dd/MM/yyyy. Thanks David "David Biddulph" wrote: It's well worth looking at the Windows Regional Settings (in Control Panel). -- David Biddulph "Cookie" wrote in message ... A colleague of mine has a spreadsheet with various dates in them in the format dd/mm/yyyy. Some of the dates where the day is less than 13 keep toggling between displaying dd/mm/yyyy and mm/dd/yyyy, however, if they are formatted as dd-mmm-yyyy they display the correct date and month. This only seems to happen on the pc at work and not at home which implies some configuration issue. I have seen this problem before myself but never got to the root cause, does anyone out there have a reason and hopefully a resolution to this issue? Thanks David |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
| "Excel encountered an error and had to remove some formatting toavoid corrupting the workbook. Please re-check your formatting carefully." | Excel Discussion (Misc queries) | |||
| Excel 2003: Error with date formatting | Excel Discussion (Misc queries) | |||
| Data Formatting Error | Excel Discussion (Misc queries) | |||
| date formatting error | Setting up and Configuration of Excel | |||
Hybrid Mode
