How to Change Negative Numbers to Positive Numbers in Excel (2 Easy methods)

preview_player
Показать описание
In this video, I will show you a couple of easy ways to change negative numbers to positive numbers.

You can do this using Excel formula such as ABS or IF, as well as using Paste Special

With Paste Special, you can reverse the sign of all the numbers, or you can choose the negative numbers first and then change the negative numbers to positive numbers,.

This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.

⚙️ Gear I Recommend:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial
Рекомендации по теме
Комментарии
Автор

Excellent explanation, well demonstrated, Thanks.

psyadavji
Автор

Thankyou sir

Additionally, we can use REPLACE "-" with nothing, to convert negetive to positive.

KaushalKumarKK
Автор

Thanks a lot I needed that works fantastic

williamlomprez
Автор

Your way of teaching is very good. Can you please share some VBA related Video., so that i can learn some new things.

nityanandamohanty
Автор

Thanks mayn, , , in a min u solved my issue

kransang
Автор

Hi! Trump excel. I need your tutor skills. I like your guides and I keep learning from them with ease. I have a data set I want to map a column if year=a and year=b lookup skus code then it will show old price else if year =b new price. Something like that..

SweetAngelAstrea
Автор

Sar please Excel ka full course video banaaiye . Jismein sare important topics like micros pivot table we lookup h lookup jaise sare topics cover
Ho

nitinjohri
Автор

2:40 Paste Especial > Multiply
3:40 Localizar e Substituir

planxlsm
Автор

find what is still giving me posture and negative numbers

excusemybeauty
Автор

Can't it be simple just find - and replace with nothing

rajanraj