Forum Discussion
Display percentage without space between number and %
Hi and thanks for the replies and comments.
I just deleted a post giving some more details, and images. However, I tried to change the "regional format" of windows from Norwegian to English and could literally see the space disappearing once I did. So that is the answer right there.
Now, the reason why I didn't try this previously was 1) I have the same issue on my work PC and have tried to mess around with the "regional formatting" before without any luck. I will try it again thought, but it may be controlled by my organization. 2) I do not think this was the case before I upgraded to Office 365 as I had never noticed it before and just upgraded to Office 365 today and naturally noticed straight away.
Edit: As far as I know, it is not possible to alter the way % is displayed in Excel without changing the "Regional formatting". So if you want Norwegian formatting but no space between the number and the %, then at least I do not know how this is done..
PS....
``if you want Norwegian formatting but no space between the number and the %, then at least I do not know how this is done``
Oh, but you do. As you said at the outset: ``I can always change this with custom formatting``. To wit: Custom 0% works just fine.
However, your previous point was: ``I would like to change so that the default formatting for percentage is without the space before "%"``. I concur: I do not see any way to change the default Percentage format for Norwegian. (sigh)
Re: ``I do not think this was the case before I upgraded to Office 365 as I had never noticed it before and just upgraded to Office 365 today``
I do not believe it has anything to do with Office 365 or a recent update thereto.
I use Excel 2010 on Win7. When I select either of the two standard Norwegian settings (Bokmal and Nynorsk) in "Region and Language" control panel, I do indeed see the space before "%" -- even in the Format menu accessible from the "ribbon". Look closely:
