Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 24th 05, 03:11 PM
CindyatRWD
 
Posts: n/a
Default How do I convert numbers to the opposite sign?

I need to change all positive numbers in the spreadsheet to negative numbers,
and vice versa in Excel.

  #2   Report Post  
Old October 24th 05, 03:17 PM
damorrison
 
Posts: n/a
Default How do I convert numbers to the opposite sign?

times it by -1

  #3   Report Post  
Old October 24th 05, 03:19 PM
Dave Peterson
 
Posts: n/a
Default How do I convert numbers to the opposite sign?

Put -1 in an empty cell
edit|copy that cell
select your range to fix
Edit|paste special|check multiply.



CindyatRWD wrote:

I need to change all positive numbers in the spreadsheet to negative numbers,
and vice versa in Excel.


--

Dave Peterson
  #4   Report Post  
Old October 24th 05, 03:24 PM
bpeltzer
 
Posts: n/a
Default How do I convert numbers to the opposite sign?

Type a '-1' in some random cell and copy it (ctrl+C). Then select the cells
you want to switch and Edit Paste Special, select Values and Multiple and
click OK.


"CindyatRWD" wrote:

I need to change all positive numbers in the spreadsheet to negative numbers,
and vice versa in Excel.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert numbers to text bellman Excel Discussion (Misc queries) 0 October 4th 05 10:28 PM
Align $ sign next to numbers Christina Excel Discussion (Misc queries) 5 April 7th 05 07:21 PM
How do I sum hours in Excel and convert to decimal numbers? Heinsohn Excel Discussion (Misc queries) 2 March 5th 05 07:48 PM
Is there a formula to convert numbers to written text in Excel? LZC Excel Worksheet Functions 3 November 27th 04 08:10 PM
how do i convert numbers to words MazenBy Excel Worksheet Functions 2 November 16th 04 05:28 PM


All times are GMT +1. The time now is 03:49 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017