LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
vesuvius
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formulas to numbers Steve New Users to Excel 2 September 16th 05 12:07 AM
Converting Formula answers to numbers pugsly8422 Excel Discussion (Misc queries) 3 September 9th 05 03:47 PM
converting dates into numbers help me Excel Discussion (Misc queries) 3 December 17th 04 03:11 AM
Converting numbers P Boric Excel Worksheet Functions 1 November 28th 04 07:39 PM
Converting text to numbers Scott Excel Discussion (Misc queries) 3 November 26th 04 09:17 PM


All times are GMT +1. The time now is 09:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"