Convert negative values to zero in Excel

preview_player
Показать описание
The video offers a short tutorial on how to convert negative values to zero in Excel.
Рекомендации по теме
Комментарии
Автор

Could you write in the comments the info you wrote when formatting the cells?

chelseacovington
Автор

Why does the function bar still show the negative values in the cells?

Terifiq
Автор

very helpfull. I am just seeking this in if comands

dishantkhullar
Автор

I want to see how to do it not see it done.

paulmeoff
Автор

THANKS BOSS, VERY USEFUL,
USE THIS #, ##0;"0"

UpendarKumar-ocvq
Автор

nobody can see what you are typeing there

bogdannitu
Автор

this is not working if you are having a formula thats calculating the given cell....it still calculates with the old value....so the best way would be to change the negative value to 0 so that formula takes 0 as value of the cell...and you dont have a solution to ;)

SalkoDinamitas