Formatting numbers

[SwissBoy]

Hi

I'd like to format my colum (by the way, all numbers are always multiples of 1/4) in this way (right aligned; ones below ones):

I'm looking for one single format for the whole column. I've tried with no success

#0,?? (2 is shown as 2,)

#0_,_0_0 (3,25 is shown as 3)

[=2]#0_,_0_0;#0,?? (doesn't work in line 3)8)

etc.

Any ideas?

Thanks in advance,

Remo

[#2 · Accepted solution]

@SwissBoy 

Standard number formatting cannot do this. You can use conditional formatting though. See the attached sample workbook.

[#3]

@Hans Vogelaar
That was the right idea! Thank you, Hans, for pointing out conditional formatting.
Remo

[#4]

@SwissBoy 

If numbers are manually entered that could be like

[#5]

@Sergei Baklan 

Hi Sergei,

That doesn't align the last digit of the integer part of the numbers...

[#6]

@Hans Vogelaar 

True, thank you