- Joined
- 21 Mar 2002
- Messages
- 1,693
At work I have to send out spreadsheets with prices on, and sometimes I just get a column with certain prices and add 5% to the lot, i.e. column F shows the original price, and column G shows column f + 5%. The problem with this is that the data in column G are reliant upon the data in F; if I delete column F then I lose all my data from column G. The only way around that I have found is to just copy and paste the data from G into notepad and then back again. This causes the data in the cells to become actual "numbers" instead of the results of formulae, meaning that I can delete column F with no consequences to column G. Is there a better way of doing this?
If anyone can understand that what I mean then I'll send reps out for that alone!
Thanks.
If anyone can understand that what I mean then I'll send reps out for that alone!
Thanks.