I have a problem with excel that sounds simple but I can not find a solution and hope someone might have a solution for me.
I try to specify a row in excel as negative numbers. For example I like to specify row B as being negative. so that when someone types in a number into row B it is automatically made negative. So if someone would type in 100 in an cell in row B it would change it to -100.
I found some suggestions but nothing that does it automatically. It is a sheet that calculates inventory and several employees have access. so if someone would forget to type the minus sign in front of the negative number then it would mess the inventory up. Therefore, I look for a code, formula or something that allows me to check any value typed into a specified row and if it is not a negative number it should automatically convert it to -
Can this be done?