| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I remove a sum but keep the figures in excel
I have set up an excel document where I have values in row E, and have put a
simple formula into row F (example: E3*1.06). Now I want to use the figures I have got from the sum into a different workbook, but I do not want to show the formula. Is there anyway of doing this - all I seem to get is error messages! Thanks, Nicola |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I remove a sum but keep the figures in excel
Use Copy from Document/Column F and Pastespecial/Values into different
workbook. Regards, Stefi €˛icklnickla€¯ ezt Ć*rta: I have set up an excel document where I have values in row E, and have put a simple formula into row F (example: E3*1.06). Now I want to use the figures I have got from the sum into a different workbook, but I do not want to show the formula. Is there anyway of doing this - all I seem to get is error messages! Thanks, Nicola |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I remove a sum but keep the figures in excel
Thanks that worked!
"Stefi" wrote: Use Copy from Document/Column F and Pastespecial/Values into different workbook. Regards, Stefi €˛icklnickla€¯ ezt Ć*rta: I have set up an excel document where I have values in row E, and have put a simple formula into row F (example: E3*1.06). Now I want to use the figures I have got from the sum into a different workbook, but I do not want to show the formula. Is there anyway of doing this - all I seem to get is error messages! Thanks, Nicola |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I remove a sum but keep the figures in excel
You are welcome! Thanks for the feedback!
Stefi €˛icklnickla€¯ ezt Ć*rta: Thanks that worked! "Stefi" wrote: Use Copy from Document/Column F and Pastespecial/Values into different workbook. Regards, Stefi €˛icklnickla€¯ ezt Ć*rta: I have set up an excel document where I have values in row E, and have put a simple formula into row F (example: E3*1.06). Now I want to use the figures I have got from the sum into a different workbook, but I do not want to show the formula. Is there anyway of doing this - all I seem to get is error messages! Thanks, Nicola |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I remove the annoying automatic date formatting in Excel? | Excel Discussion (Misc queries) | |||
| Remove trailing spaces from multiple columns in Excel | Excel Worksheet Functions | |||
| How to combine Excel 2002 files and remove duplicate records? | New Users to Excel | |||
| How can I remove a large page number from each page in Excel | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Linear Mode
