Forum Discussion
SwissBoy
Aug 17, 2022Copper Contributor
Formatting numbers
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)😎
etc.
Any ideas?
Thanks in advance,
Remo
Standard number formatting cannot do this. You can use conditional formatting though. See the attached sample workbook.
True, thank you
Standard number formatting cannot do this. You can use conditional formatting though. See the attached sample workbook.
- SwissBoyCopper Contributor