| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL HOW TO ADD 100 to all my values in a column
I rarely use excel, but from time to time i have to create certain reports, i
have column G with 50 numbers, and i would like multiply each number by 100. I dont want to go one by one, please help me out, thank you..have a nice day... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
EXCEL HOW TO ADD 100 to all my values in a column
put 100 in a cell somewherecopy that cellselect your columneditpaste
specialmultiply -- Don Guillett SalesAid Software "drhell" wrote in message ... I rarely use excel, but from time to time i have to create certain reports, i have column G with 50 numbers, and i would like multiply each number by 100. I dont want to go one by one, please help me out, thank you..have a nice day... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
EXCEL HOW TO ADD 100 to all my values in a column
In an us-used cell, enter 100 anc opy that cell.
Select your column of cells and: Edit PasteSpecial and check the multiply box This will multiply each of the munbers by 100. To add 100 to each number, check the Add box instead. -- Gary's Student gsnu200701 "drhell" wrote: I rarely use excel, but from time to time i have to create certain reports, i have column G with 50 numbers, and i would like multiply each number by 100. I dont want to go one by one, please help me out, thank you..have a nice day... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Calculate an Excel column that contains numbers and #Values | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
Linear Mode
