| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to add .12 cents to every item in a column
I need to add .12 cents to every item in a column on my pricelist is there an
easier way to do this? -- claudia |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to add .12 cents to every item in a column
Put .12 in any unused cell
copy that cell select the range to change edit paste special add -- Don Guillett Microsoft MVP Excel SalesAid Software "claudia" wrote in message ... I need to add .12 cents to every item in a column on my pricelist is there an easier way to do this? -- claudia |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to add .12 cents to every item in a column
Hi.
Put 0.12 in a cell and copy it. If your cell is formatted as currency be sure to use the same format on this cell or you'll lose your formats. Select your range and then Edit|Paste special Select add Click OK Mike "claudia" wrote: I need to add .12 cents to every item in a column on my pricelist is there an easier way to do this? -- claudia |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Item in Other Column and Repeat | Excel Discussion (Misc queries) | |||
| does item match any in column B | Excel Discussion (Misc queries) | |||
| How do I tell Excel to find the last item in a column? | Excel Discussion (Misc queries) | |||
| Counting item in a column | Excel Discussion (Misc queries) | |||
| Returning the last item in column | New Users to Excel | |||
Hybrid Mode
