Changing the formula to the number shown

A

am4428

I am working on 2006 pricing for our home improvement company. One of
our suppliers said they are raising their prices by a certain
percentage. I created a simple formula to get this years pricing.
=C4*6%+C4 I was wondering if there was a way to make that cell become
only the number the formula created. Thus being able to delete last
years pricing column.

Thanks!
Audrey
 
P

poddys

Take the column of new prices and select the values.
Copy (Edit-Copy or Ctrl-C).
Select the equivalent cells with old prices.
Do an Edit-Paste Special and select Value.
Instead of pasting a formula into the old cells, this will paste just
the result value of your new column.

PS: Please make a backup copy before you do this..... It's easy when
you know what you are doing but it's also incredibly easy to make
mistakes too..........

Hope this helps.
 
Top