how to not display the coma sign for integers in excel

Question

OKAY, I have not worked with Excel since the last millennium, so I am not fresh. In German Excel we have "," as float delimiter.

To cut a long story short ... this is what I want:

one and a half pixel is:  1,5 px
one pixel            is:    1 px
ten pixel            is:   10 px
half of a  pixel     is:  0,5 px

So I then tried to set up a custom number format with which I can then display the numbers as pixels

####0,#### px

The numbers then look like this:

one and a half pixel is:  1,5 px
one pixel            is:   1, px
ten pixel            is:  10, px
half of a  pixel     is:  0,5 px

Then I tried this

####0,0#### px

The numbers then look like this:

one and a half pixel is:  1,5 px
one pixel            is:  1,0 px
ten pixel            is: 10,0 px
half of a  pixel     is:  0,5 px

But I don't want to draw a coma with integers , is there a solution?

user_9758194 · Answer

Maybe just use the german equivalent of:

General px

In the picture above I used the Dutch equivalent: Standaard px. And yes, here too, the decimal comma is used as per my locale settings.