Stock Market Financial Calculations

[rcthomp1]

How is it possible to retain the cell data, when the calculation is deleted or moved? I want to keep my data when moving to a new spread sheet.

[Harribone]

Not entirely sure what you are getting at exactly but if you have a sheet with formulas to create your data and you want to copy this to a new sheet to save this data then you need to copy and then right click and paste special>values. This removes any calcs/formulas and just populates the sheet with actual figures.

[rcthomp1]

You interpreted my request correctly and I was able to remove the calculations from the cells BUT retain the data. Thanks a bunch

[Harribone]

Don't forget to mark this thread as SOLVED. This can be found under 'thread tools' at the top.