Format cell by adding "+" in dollar positive values without affecting formulas (Google Sheets) [duplicate]

Question

I have the following values:

And I would like positive values to come with the "+" sign before the dollar symbol, I know this can be done by adding IF > 0, "+"&

But in this way, it affects the calculations of all other cells that depend on the results obtained in those cells.

I wonder if there is any way to format this cell without affecting via formula.

I tried to put:

"+"$0;"-"$0;$

In custom coins, but it didn't work out.

player0 · Accepted Answer · 2019-11-16 12:44:27Z

6

try this under custom number format:

+$#,##0.00;-$#,##0.00;$0.00

answered Nov 16, 2019 at 12:44

player0

131k14 gold badges91 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1