Thread
:
ADD A DOLLAR VALUE TO ALL DATA
View Single Post
#
2
Posted to microsoft.public.excel.newusers
Don Guillett
external usenet poster
Posts: 10,124
ADD A DOLLAR VALUE TO ALL DATA
one simple way
put 1 in a cellcopy that cellselect all cells to
changeeditpastespecialadd
--
Don Guillett
SalesAid Software
"mastequila" wrote in message
...
If I have a shipping spreadsheet that has a shipping
cost shown by weight on the left and zone on the top , how can i select
all
fields and add a certain dollar amount to every field ???
For example
Zone 1 zone 2
1Lb 1.00 2.00
2Lb 2.00 3.00
3Lb 3.00 4.00
How do I select all the shipping fees and add say 1.00 to the current
rates
???
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett