Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel how do I add a flat 10.00 in a column with 10 entries
Need to add a a flat amount of 10.00 in each entry ex
112.00 134.00 154.00 ect |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel how do I add a flat 10.00 in a column with 10 entries
In a blank cell type 10, then copy the cell. Highlight the cells to which 10
is to be added, click Edit Paste Special and select Value and Add, then OK "Jdetuya" wrote: Need to add a a flat amount of 10.00 in each entry ex 112.00 134.00 154.00 ect |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel how do I add a flat 10.00 in a column with 10 entries
Enter 10 in some empty cell and copy that cell. Then select the
number you want to change, go to the Edit menu, choose Paste Special, select the Addition option, and click OK. You may now delete the cell in which you entered the 10. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Jdetuya" wrote in message ... Need to add a a flat amount of 10.00 in each entry ex 112.00 134.00 154.00 ect |
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 | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
How do I set up an Excel column to not allow duplicate entries (m. | Excel Discussion (Misc queries) | |||
set up a column in excel with unique entries | Excel Discussion (Misc queries) |