I'm working on checking for negatives in an Excel sheet. The way information comes to me, it uses {#-} (# representing a number). So when I try to check if it is negative, it believes it is postive.

Ex. -2 = Negative but 2- is Positive.

Because of this issue, I'm trying to create a formula that figures if a cell has a "-" in it, then =LEFT(E22,1)*-1, otherwise, just display the positive value.

What combination would be easier? I'd appreciate any help with this one...