troubleshooting Question

Specifie Excel Row as negative

Avatar of Thomas
ThomasFlag for Malaysia asked on
Microsoft ExcelSpreadsheetsVB Script
4 Comments1 Solution384 ViewsLast Modified:
Hi,

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?
ASKER CERTIFIED SOLUTION
Saqib Husain
Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros