express all entries in a column as negatives

L

Larry

Is there any to have all entries in a excel worksheet be
automatically expressed as negatives, without having to
enter them as -'s
 
A

Anne Troy

Sure. Once you're done entering all the data, type -1 into any cell. Copy
it. Select all your data. Hit Edit-Paste special, Multiply, Ok. Multiplying
any number by -1 makes it a negative number, right?
:)

**** Hope it helps! ****

~Dreamboat
Excel VBA Certification Coming Soon!
www.VBAExpress.com/training/
********************************
 
Top