converting a positive number to neg number in spreadsheets

  • Thread starter Thread starter Spreadsheet question
  • Start date Start date
S

Spreadsheet question

Is it possible to change numbers in spreadsheet cells from say -1.00 to 1.00
 
Hi,

Put -1 in a cell and copy it. Select your number(s) and then

Edit|Paste Special - select multiply - OK

Delet the -1

Mike
 
If you want to do it with a formula, it's:
=-a1

Adjust the range to suit.

Regards,
Fred.
 
On the off-chance the cell could have *either* positive or negative values
in it, and assuming the OP would want to keep the positive values as
positive while only changing the negative values, that formula would be...

=ABS(A1)
 
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

I am trying to use the IF and SUMIF function on Excel 8
IF THEN formulas 1
Sequentially adding a day to total 3
Create Excel Lab test results 1
Convert neg. numbers to positive numbers 10
Showing Last number only 6
Comparing dientical part numbers but with different prices 3
FORMULA Sorts neg numbers as positive.. 2

Back
Top