Converting functions into numbers
For example, using the function =2*3, I will get a 6 in the cell. Now I would like to copy the 6 into another cell. Using the usual copy, I will copy the function. Is there a way that I can copy the 6 as a number and not as a function? -- vesuvius ------------------------------------------------------------------------ vesuvius's Profile: http://www.excelforum.com/member.php...o&userid=28575 View this thread: http://www.excelforum.com/showthread...hreadid=482368 |
Converting functions into numbers
•Select source cell •Edit.Copy •Select destination cell •Edit.Paste Special -Select: Values -Click the [OK] button Is that what you're looking to do? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=482368 |
All times are GMT +1. The time now is 11:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com