I have this number:
If I format it as percentage, I obtain:
There is any way to get it with a 'thousand percent' symbol?
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.Sign up to join this community
I don't think you will be able to create a custom format to change the display. You can use this formula though.
Edit: To allow use of the text value you can use the NumberValue() function. Assuming that the Text() function above is in cell D2:
This will drop the ‰ and treat the remaining number as numeric.
It is a little cumbersome but it works.
Using a combination of the multiply by 1,000 formatting, and ALT+0137 character to add the mille symbol should get you on the right track.
For example, I was able to get ##.0,"‰",%%% to work in Excel 2010.
Remember to wrap text as referred to in the post linked to. Depending on the text in other cells, you might run into the issue of not being able to hide the extra %%% signs though. Others cells referring back to this reformatted cell should be formatted in your normal Number format to display correctly (ie without symbols etc).
The universal command for the "Per Mille" symbol (
‰) on Windows is ALT+0137.
For OS X, it is SHIFT+OPTION+R.