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?

Windows Regional Options, not in Excel.
--
David Biddulph

"Anthony Corb" <Anthony Corb@discussions.microsoft.com> wrote in message 
news:72B73E46-A92B-4335-AA2D-21E6793D4572@microsoft.com...
> 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? 

Thanks David,

I had looked at the regional settings in the control panel and it had 
appeared to be fine however (summary page) when I openned the customise 
section I noticed that the data there was not as per the summary page and so 
just used the reset button to switch back. 

Hope it works now. I don't know how these werer changed but must have been 
an update patch I ran.

Thanks again.

Anthony.   

"David Biddulph" wrote:

> Windows Regional Options, not in Excel.
> --
> David Biddulph
> 
> "Anthony Corb" <Anthony Corb@discussions.microsoft.com> wrote in message 
> news:72B73E46-A92B-4335-AA2D-21E6793D4572@microsoft.com...
> > 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? 
> 
> 
> .
>