Hi All,
I am trying to figure out how to add a fixed amount in percent (ie. 10%) to all cells in a column.
Here is an example:
Price:
1.00
2.00
2.50
3.00
3.00
5.00
I want to add 10% to everything in the above column to give:
Price:
1.10
2.20
2.75
3.30
3.30
5.50
The column has thousands of items so manual editing is not something I can complete this year ;-)
If this involves some kind of formula would this prevent me from exporting as a CSV file - or would the CSV simply contain the numbers rather than the underlying formula?
Apologies if this is a simple question but I am stumped :-?
Any help appreciated!
Thanks,
S
Bookmarks