Changing a calculation to an actual number

  • Thread starter Thread starter CMcGrann
  • Start date Start date
C

CMcGrann

Is there a way in Excel to change a calculated field to an actual number?
For example changing =B2 (10)+C2 (12) to actually be 32? I want to use this
field in a seperate system, can it will not copy since it is a calcuated
field. Thanks.
 
Hi,

Select the fomula cell and copy it and while still in that cell
edit|Pastespecial
select Values
Click OK


Mike
 
If you are only doing one cell - I suggest hitting the F2 key then the F9
(not together) and then hit enter.....
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time calculations for Scheduled Time vs. Actual Time Worked 1
Time calculations for Scheduled vs Actual Employee Time and Wages 4
Time calculations for Scheduled vs Actual Employee Time and Wages 2
Calculating time values 2
Show difference between tow numbers as a + or - value. 3
Calculated Items in Pivot Table 1
Formatting Dates from Text to Numbers 2
Calculating elapsed days and hours 4

Back
Top