| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change from a sum reference to the number
Hi,
I have numbers on one worksheet that are the sum of other numbers....e.g. the contents of the cell are =sum(a3:e3) I'd like to copy that cell to another worksheet, but I want the number, not the =sum(a3:e3). Can you give some advice? Thanks chuckm |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change from a sum reference to the number
Chuck, copy the cell then edit paste special ,valves
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 97 & 2000 ** remove news from my email address to reply by email ** "ChuckM" wrote in message m... Hi, I have numbers on one worksheet that are the sum of other numbers....e.g. the contents of the cell are =sum(a3:e3) I'd like to copy that cell to another worksheet, but I want the number, not the =sum(a3:e3). Can you give some advice? Thanks chuckm |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change from a sum reference to the number
When you paste, use paste special then pick the "values"
option. -----Original Message----- Hi, I have numbers on one worksheet that are the sum of other numbers....e.g. the contents of the cell are =sum(a3:e3) I'd like to copy that cell to another worksheet, but I want the number, not the =sum(a3:e3). Can you give some advice? Thanks chuckm . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shortcut to change change cell reference to Absolute reference? | Excel Worksheet Functions | |||
| change change cell reference to Absolute reference | Excel Discussion (Misc queries) | |||
| How to change a reference when the sheet change the folder? | Excel Worksheet Functions | |||
| How do I change my cell reference columns from number to alphabet? | Excel Worksheet Functions | |||
| Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions | |||
![ChuckM[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
