ca1358
asked on
Make a Excel Cell default to a negative number
Using Excel 2003
How do you make a cell default to a negative number?
How do you make a cell default to a negative number?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
hi, i tried the code and it was successful for a range like from cell b11 to b55. or b11 to m11 but what if i would also like other cell ranges in the spreadsheet to reflect as negative? like cell g55, z45 etc? not on the same row or column? can you help me on it? i tried adding the range arguements to the line in --> If Intersect([A1:A100], Target) Is Nothing Then Exit Sub <--- like [G55:M55], [E42] but it seems they all just become positive. but if it's only one bracket range like the [A1:A100] then it's ok. pls help thanks.
Specify the ranges within the square brackets, like this...
[A1:A10, C1:C5, G55, Z45]
Wayne
[A1:A10, C1:C5, G55, Z45]
Wayne
Thanks!! yes was about to do that, just didn't quite understand excel's cryptic commands. :)
cheers!!!
cheers!!!
ASKER