Negative Returns

Hi,

I want to key-in positive numbers, which I really want Excel to interpret as being NEGATIVE numbers.

In other words, I want to avoid repeatedly striking the MINUS key.

How do I:

Format these Data-Entry cells to this?
Format these Data-Entry cells to return RED displays?


I'm using Excel 2000

Cheers,
Mick

One way if you did not want to use VBA would be,

If you have a number in A1 in B1 you would normally use =A1 to refer to that cell, instead use -A1 and the value will be negative, format B1 to the number format you want.

The VBA way, would be to use a code like this, placed in the worksheet module, so whenever a number was entered into column A the value would change to Negative

Please Login or Register  to view this content.

Right click on the sheet tab and select View Code, paste the code there.