Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |