Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
LoriK
 
Posts: n/a
Default DECREASE ALL NUMBERS IN A COLUMN BY A PERCENTAGE

I'm not knowledgable in excel. Can someone explain, in simple terms, how to
decrease all numbers in a column on a spreadsheet by a percentage? Thank you.
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
e.g. to decrease all by 5%:
- enter 0.95 in an empty cell and copy this cell
- select your values
- goto 'Edit - Paste Special' and choose 'Multiply'

--
Regards
Frank Kabel
Frankfurt, Germany

LoriK wrote:
I'm not knowledgable in excel. Can someone explain, in simple terms,
how to decrease all numbers in a column on a spreadsheet by a
percentage? Thank you.



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
no row numbers or column letters DISPLAYED RagDyer Excel Discussion (Misc queries) 4 April 24th 23 03:42 AM
Excel column headings from numbers to letters happygolucky Excel Discussion (Misc queries) 2 January 21st 05 06:15 PM
row numbers & column letters ALOlson21 Excel Discussion (Misc queries) 3 December 10th 04 05:45 PM
Small font on row & column numbers - wierd Mike R. Excel Discussion (Misc queries) 1 December 4th 04 12:32 PM
column headings display as numbers JayT Setting up and Configuration of Excel 2 November 29th 04 06:51 PM


All times are GMT +1. The time now is 03:25 AM.

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"