Forum Discussion
Display percentage without space between number and %
Set format "0%" or "0.00%" (under Format cells ... -> and on the Numbers tab select User-defined and select the desired format)
Format numbers as percentages
Tips for displaying percentages
I would be happy to know if I could help.
I wish you continued success with Excel
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.
Note that I am not asking about how to format a cell as a percentage, but rather how that percentage formatting looks. When I do what you say, the cell says "50 %", but I want it to say "50%", i.e. without the space between 50 and %.
As I said in my initial post, I can fix this by using custom formatting, but I would like this way of formatting percentages to be the default.
So I don't know what your plans are, unfortunately nothing precise can be found in the translation. Maybe it would help more if you submit an example file (without sensitive data) with an explanation based on this file.
Nevertheless, here is a suggested solution, as I could understand from the translation.
Solution proposal :
=TEXT(50;"###\%")
I hope that I could help you with this information / links.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here
NikolinoDE , the problem is if you apply percent format to number, e.g. to 0.5, it returns "50 %" (with space), not 50%.
That's not clarified on which operational system (iOS, Windows,...) and which version of Excel that happens, but in any case I don't know which setting could be responsible for that. Maybe you know.
Re: ``if you apply percent format to number, e.g. to 0.5, it returns "50 %" (with space), not 50%``.
Say what?! Not on my version of Excel (Excel 2010 on Win7 on a PC). See the attached Excel file and image.
