custom formatting with prefix on negative value

[y3tter]

I have a value of -8.53 and I am trying to put a custom formatting on it to display "N/S: -8.53'". This is what I am using "N/S: "##,###.00"'" but it is placing the negative before the prefix. How can I keep the negative in front of the numerical value instead?

 

[RoryA]

Add a negative section:

"N/S: "##,###.00"'";"N/S: "-##,###.00"'"

 

[Rick Rothstein]

Try using this Custom Format instead...

"N/S: "#,###.00';"N/S: "-#,###.00'

 

[y3tter]

Awesome, thanks guys! It works great!

 

[Rick Rothstein]

Awesome, thanks guys! It works great!

You are welcome. Just pointing out that while both posted custom formats work exactly the same, they are not identical.