Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default convert a sum to a number that can be moved to another location

Can I convert a sum number to a number that can be copied to another cell
minus the formula.
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 35,218
Default convert a sum to a number that can be moved to another location

Select the cell
Edit|copy
go to the other cell
Edit|paste special|values

These are xl2003 menus.

You can also rightclick on each cell and get the same functionality.

peteFL wrote:

Can I convert a sum number to a number that can be copied to another cell
minus the formula.


--

Dave Peterson
Reply
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
Macro - save to current location vs excel default location leezard Excel Discussion (Misc queries) 0 October 28th 08 03:04 PM
plotting location of a number within a range Steve Winters Charts and Charting in Excel 1 February 15th 07 03:09 PM
using a number to select cell location Trevor Excel Discussion (Misc queries) 2 July 3rd 06 05:49 AM
convert text-format number to number in excel 2000%3f Larry Excel Discussion (Misc queries) 1 July 29th 05 08:18 PM
convert decimal number to time : convert 1,59 (minutes, dec) to m agenda9533 Excel Discussion (Misc queries) 8 January 20th 05 10:24 PM


All times are GMT +1. The time now is 03:41 PM.

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

About Us

"It's about Microsoft Excel"