change sheet1 to sheet2 AccountAmount245082106.6868121000-6.682450821033.85245082104.282450821024.002450821031.562450821064.462450821048.1364015000-48.13 65031000-33.8565080000-24.0066010000-677.3266020000-4.2866020000-31.5666020000-64.46 sheet2 AccountAmount24508210-6.68681210006.6824508210-33.8524508210-4.2824508210-24.0024508210-31.5624508210-64.4624508210-48.1324508210-677.326401500048.136503100033.856508000024.0066010000677.32660200004.286602000031.566602000064.46

How to add Negative sign to all value？

change sheet1 to sheet2

Account	Amount
24508210	6.68
68121000	-6.68
24508210	33.85
24508210	4.28
24508210	24.00
24508210	31.56
24508210	64.46
24508210	48.13
64015000	-48.13
65031000	-33.85
65080000	-24.00
66010000	-677.32
66020000	-4.28
66020000	-31.56
66020000	-64.46

sheet2

Account	Amount
24508210	-6.68
68121000	6.68
24508210	-33.85
24508210	-4.28
24508210	-24.00
24508210	-31.56
24508210	-64.46
24508210	-48.13
24508210	-677.32
64015000	48.13
65031000	33.85
65080000	24.00
66010000	677.32
66020000	4.28
66020000	31.56
66020000	64.46

Transformation

Accepted answers

BS_THE_ANALYST

@phoebe_90 if you want to overwrite the existing column, instead of creating a new one:

flipTheSign.yxmd

All comments

BS_THE_ANALYST

@phoebe_90 you just need to use a formula tool like so:

Mutiply the column by -1

BS_THE_ANALYST

@phoebe_90 if you want to overwrite the existing column, instead of creating a new one:

flipTheSign.yxmd

JitendraPal

First of all, change the data type for the Amount field to either Double or Float by using select tool, then use the formula tool ([Amount]* (-1)) to get the desired result.

Arjunmarwaha09

looks good

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703