Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formulas to numbers | New Users to Excel | |||
Converting Formula answers to numbers | Excel Discussion (Misc queries) | |||
converting dates into numbers | Excel Discussion (Misc queries) | |||
Converting numbers | Excel Worksheet Functions | |||
Converting text to numbers | Excel Discussion (Misc queries) |