 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / May 2008Changing a calculation to an actual number
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 > 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. Yes, ... but I hope that the OP wanted 22, not 32. :-) -- David Biddulph > Hi, > [quoted text clipped - 10 lines] >> field in a seperate system, can it will not copy since it is a calcuated >> field. Thanks. You mean 10 + 22 isn't 32!! lend me some fingers please :) > Yes, ... but I hope that the OP wanted 22, not 32. :-) > -- [quoted text clipped - 14 lines] > >> field in a seperate system, can it will not copy since it is a calcuated > >> field. Thanks. Use copy>edit>paste special values or the copy/paste icons  SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > 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. If you are only doing one cell - I suggest hitting the F2 key then the F9 (not together) and then hit enter..... SignatureWag more, bark less > 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.