Forum Discussion
Display percentage without space between number and %
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.
That's I repeated the question (see very first post) for NikolinoDE since it was some misunderstanding.
