**Question description:**

*This user has given permission to use the problem statement for this blog.*

How do I change a column of (-) Negative values to Positive? (+) I have a list of business expenses on a spreadsheet.

Solved by X. W. in 30 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
01/04/2017 - 04:36

Hi

User
01/04/2017 - 04:36

No I think this will do it...

Excelchat Expert
01/04/2017 - 04:38

just multiple it by -1

Excelchat Expert
01/04/2017 - 04:38

so suppose if cell A1 is -5, then in some helper column use the formula,

Excelchat Expert
01/04/2017 - 04:39

=A1*-1, then copy the output back as values in A1

User
01/04/2017 - 04:41

Oh! ok I think I get it. Can I give it a try while you are still with me?

Excelchat Expert
01/04/2017 - 04:42

yes, please

Excelchat Expert
01/04/2017 - 04:42

I am here only

User
01/04/2017 - 04:42

great please hold...

Excelchat Expert
01/04/2017 - 04:45

ok

User
01/04/2017 - 04:49

there are about 100 values that need to be changed. How do I define the entire range. Rather than a single cell?

Excelchat Expert
01/04/2017 - 04:49

you can just drag the formula down, if its all in one column

Excelchat Expert
01/04/2017 - 04:49

use it with if condition

Excelchat Expert
01/04/2017 - 04:49

like this

Excelchat Expert
01/04/2017 - 04:50

=if(A1<0,A1*-1,A1)

Excelchat Expert
01/04/2017 - 04:50

copy this formula in helper column and drag it down

User
01/04/2017 - 04:51

ok thank you please hold while I give it a try...

Excelchat Expert
01/04/2017 - 04:51

ok, I am here only

Excelchat Expert
01/04/2017 - 04:59

Hi, it worked or not?

User
01/04/2017 - 04:59

Im having trouble getting it to work, im sorry. i know your time is limited.

Excelchat Expert
01/04/2017 - 05:00

you can upload your sheet here and I can help

Excelchat Expert
01/04/2017 - 05:00

if data is not confidential or you can share sheet with dummy data

User
01/04/2017 - 05:01

ok

Excelchat Expert
01/04/2017 - 05:03

about 3 minutes remaining in session, if your query is still not resolved, you can follow me here

Excelchat Expert
01/04/2017 - 05:03

https://docs.google.com/spreadsheets/d/1FngSUKFgjgSki9y12vuFlmM4LyxgooIiegxR2fOoXyI/edit?usp=sharing

Excelchat Expert
01/04/2017 - 05:03

if the session ends

User
01/04/2017 - 05:05

ok thank you i will

Excelchat Expert
01/04/2017 - 05:05

also, can you upload your sheet

Excelchat Expert
01/04/2017 - 05:05

before the session ends

User
01/04/2017 - 05:05

yes