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.
5 Replies
- SergeiBaklanDiamond Contributor
- SergeiBaklanDiamond Contributor
True, thank you
Standard number formatting cannot do this. You can use conditional formatting though. See the attached sample workbook.
- SwissBoyCopper Contributor