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