multi column sign flipping

[wlee-pwc]

I am trying to flip the sign to all the values in the screenshot (there a lot more columns than what the screenshot shows...at least 50 more).  What is the best way to go about it? 

Thank you in advance.

[Thableaus]

Hi @wlee-pwc 

Like -0.00? 

This is not possible with Numeric Field Types.

You'd have to convert your fields to String Types and concatenate a "-" in front of the 0 values. But they wouldn't be numeric for calculations anymore.

Cheers,

[wlee-pwc]

Sorry, I meant the opposite.  It is currently putting a "-" in front of the all the 0's so they look like -0.  I want to exclude it.  How would I include a command in the multi-field tool to flip the signs (like you have already shown in your first solution) but ignore 0's.