I am using format cells to add text to cells.

My problem is when the cell value is negative. The negative location change to be in front of the text.

How do you move the negative sign in Excel next to the number (blue line in the picture above)?

Thank you for your help,

CodePudding user response：

Try conditional custom formatting.

[<0]"tt" -0.000 "ksi";"tt" 0.000 "ksi"