negative sign with cell is formatted with a text in it

Viewed 18

I am using format cells to add text to cells. enter image description here

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

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

Thank you for your help,

1 Answers

Try conditional custom formatting.

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

enter image description here

Related