JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,535
- Office Version
- 365
- Platform
- Windows
I can have different formats for positive, negative, and zero values: +0;-0;=0.
And I can have different formats up to two conditional value ranges: [<1]0.00;[<10]0.0;#,##0.
Is there any way to combine the two so that I can both the +/-/= prefix and the variable number of decimal places?
I would like the numbers in the left column formatted as shown in the right column:
<tbody>
</tbody>
Can this be done?
And I can have different formats up to two conditional value ranges: [<1]0.00;[<10]0.0;#,##0.
Is there any way to combine the two so that I can both the +/-/= prefix and the variable number of decimal places?
I would like the numbers in the left column formatted as shown in the right column:
-23.45 | -23 |
37.52 | +38 |
7.83 | +7.8 |
-1.28 | -1.3 |
0.737 | +0.74 |
-0.482 | -0.48 |
0 | =0 |
<tbody>
</tbody>
Can this be done?