MS Excel 2007/2010. Change number format

Auteur Réponses
ilibarra Mercredi 30 Mai 2012 à 23:45

Hey everybody!

I'm using Office 2010 in Ubuntu 12.04, with playonlinux 4.0.18 and wine 4.5.3.

My question is related with the numbering format that the cells of MS Excel have by default. For example "4.444,3" and "4,444.3". When I executed Office for the first time after I installed it, the first example was the default configuration, but I would like to have the second one. Sincerely, I have no clue where to modify it.

I checked the following registry inside the configuration of wine

"HKEY_CURRENT_USER\\Control Panel\\International"

and I found the entries "sDecimal" and "sThousand". Changing them have no effects, but I guess those are the variables I should change. In Win XP the number format changes after you modify them. I tried rebooting the OS after modify them and nothing happened.

I would like to ask if someone knows if this particular configuration that I want is possible to do. Thanks!

Ignacio Ibarra

Edité par ilibarra

ilibarra Vendredi 1 Juin 2012 à 2:26

I solved my problem. Everything I needed to do was to modify the "locale" environment variable of Ubuntu. The wine registry doesn't work and the numbering format is given by those variables.

enerkey Vendredi 13 September 2019 à 9:53

From your post, I got a new topic. I just tell you that excel sheet could be faced on an error as like, MS Excel Has Stopped Working Error. I have been tried many hardly for solved my error but could not solve the problem. Then I fixed my excel error issues from this article. So excel user can be solved there excel error issue.