Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
jjshariff
 
Posts: n/a
Default excel values from + to -

how to cahnge a selected series of values from positive to negative in one
swoop

thanks
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
- enter -1 in an empty cell
- copy this cell
- select your numbers
- goto 'Edit - Paste Special' and select 'Multiply'

--
Regards
Frank Kabel
Frankfurt, Germany

"jjshariff" schrieb im
Newsbeitrag ...
how to cahnge a selected series of values from positive to negative

in one
swoop

thanks


  #3   Report Post  
Ron de Bruin
 
Posts: n/a
Default

Hi jjshariff

Enter -1
In a empty cell and copy this cell

Select your cells with numbers
Right click on them
Paste special
Multiply
OK


--
Regards Ron de Bruin
http://www.rondebruin.nl


"jjshariff" wrote in message ...
how to cahnge a selected series of values from positive to negative in one
swoop

thanks



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
Second serie doesn't use X-as values JackRnl Charts and Charting in Excel 1 January 20th 05 01:04 AM
Missing values in Excel Line Chart mw55309 Charts and Charting in Excel 1 January 19th 05 12:10 PM
Excel user desires to learn ABC of Access Hari Excel Discussion (Misc queries) 1 December 3rd 04 02:32 AM
OPENING TWO DIFFERENT EXCEL PROGRAMS EXCEL SPREADSHEETS Excel Discussion (Misc queries) 3 December 2nd 04 11:14 PM
pivotcell object to excel 2000 Kellyc Excel Discussion (Misc queries) 0 December 1st 04 03:45 PM


All times are GMT +1. The time now is 01:43 PM.

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

About Us

"It's about Microsoft Excel"