express all entries in a column as negatives

  • Thread starter Thread starter Larry
  • Start date Start date
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
 
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/
********************************
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Negative entry 8
how do i set up a column with negative values automatically? 3
AUTOMATICALLY ENTER AND CALCULATE NUMBERS AS NEGATIVES 3
negative columns 3
Negative Numbers 8
Displaying negatives with (brackets) 3
Having the contains of a cell always be negative 5
1904 negative time 5

Back
Top