+/- format

[ammartino44]

Hello. How do I change a custom format to add + or - based on value of number?

[Ron Coderre]

• Select the range of cells to be impacted
• CTRL+1....displays the formatting window
...Number tab....Category: Custom
In the Type input box, create sections for pos, neg, zero, (and optionally text), separated by semicolons
Example:
+0.00;-0.00;0.00

Does that help?

Here's some formatting information:

Please Login or Register  to view this content.