Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
BUG - Global Format changes Number and Dates
Hi I've ben using excel for years and suddenly came up with this bug
(Currently using Excel 2007 SP2) I openned my spreadshhet one day and all my standard number formats have changed from: 1,000,000.00 To 1 000 000.00 i.e. the coma seperator no longer exists, even going to the ' button on the ribbon or to format style does not work. even the message on the tick box to insert , seperator had changed to insert ] seperator. Also I used to type UK date format 23/1 and it would default to date 23 Jan. Now I have to type 1/23. I have looked at the date and time and location setting in excel and on my system and they all seem fine. It looks like a bug in excel (I'm set up for auto MS updates so may have downloaded somthing. Some of my colleges are also having the same problem. I think somehow my global settings have gotten corrupted. Any suggestions on how I can change? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
BUG - Global Format changes Number and Dates
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change GLOBAL date format in excel? | Excel Discussion (Misc queries) | |||
global vs relative format | Excel Worksheet Functions | |||
Global Default Date Format | Excel Discussion (Misc queries) | |||
Global fix for scientific number format? | Excel Discussion (Misc queries) | |||
Number format-numbers appear as dates in Excel | Excel Worksheet Functions |