Positive number to convert into Negative number through EPM Formatting sheet

[Former Member]

Hi Friends,

I have a input template in which the user will enter data as positive number. But this number need to be saved as a negative number. I know I can do this by refereeing the input cell to another cell and using the formula (e.g - =A1*-1). But I want to do this with the formatting sheet.

So how can I have a positive number changed to negative number throught formatting sheet.

Thanks,

Rahul

[former_member186338 · Accepted solution]

Formatting will never change the sign 🙂 use Excel formula.

[Former Member]

Thanks Vadim