Excell decimal & thousands separator problem

Hello,

I have a small problem with MS excel 2000 on one of our workstations(win 2000)

It seems that the decimal point marker and the thousands separator are both set to use a period (.)

I've found the appropriate solution in the Microsoft Knowledge Base here http://support.microsoft.com/default.aspx?scid=kb;en-us;320532&Product=xlw2K however when i go to Tools\Options there is no international tab.

I've already checked the regional options in Windows 2000 and the decimal and thousands separator are both set correctly.

This problem only occurs in the users profile,when I log in as local admin its ok.I've also tried promoting the user to local admin and removing and reinstalling Excel but the settings seem to stay the same.

The profile with the problem is a domain profile hosted on a win 2000 server.When I promoted the user to local admin,why do I not get the full set of control panels?

I had to uninstall office from the cd rather than the add/remove programs control panel.Could this be the reason some settings seem to have been left behind?

A long question I know but thanks in advance for any help.

 

Interesting. Puzzling. I thought the International tab would be there regardless of the user's rights and just not available unless the account had the correct priv level.

Do you have a problem when you log on with your domain account?

Also, I think I'd try the first suggestion in that article to

, reboot, and see if he is OK then. If so, set back to whatever options you normally use and see if the fix holds.

The other possibility is a bad NT account for the user. Easy enough to delete it and add it back as a new account. Not much work unless you have lots of GPOs in and would need to spend lots of time getting the 'new' user account added to all the areas the user needs.

 

thanks,

the domain logon is fine,the settings in the regional control panel are holding fine.

It's only in Excel that I have a problem.

What did you mean by the international tab not being available depending on the users priveleges?

These aren't the same as rights?

even if I logon as local admin the tab is not there.

The version of excel we are running is Excel 2000 SR-1

Don't know if that will make a diff

Cheers.

 

With the clarification that no accounts logged on to that PC have the tab displayed, I agree that it isn't an account issue. I mis-read earlier and thought the one user didn't see the tab but others did. But for future reference, it is possible to have a corrupt NT account that mostly works fine but has problems in some areas.

And sorry, yes I was using priv. to mean the same as rights. I last posted from work where I didn't have a non-admin account to try so was just suggesting that the more usual behavior with apps is to display all tabs for all users but grey out the options for a user who didn't have rights to make a change. Some apps do simply suppress the tab being displayed at all but I don't think that's the case with Excel.

Even though the regional settings look fine, I was hoping that changing them would cause the app to 'take another look' and maybe shake loose a stuck setting then changing back and it would be using the local settings properly. Might not work but certainly can't hurt and worth a try.

Other than that I think the only other suggestion I can make is to open a service call with M$. This is the sort of thing that should be a free call.

 

Ok thanks, i'll give it a shot.I'll post back once I've cracked it.

Ta