| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy column to another spreadsheet but get value errors
I'm trying to copy a column from one spreadsheet to another but because the
cells contain functions, I get the #VALUE! error. How can I copy the cells without this happening? Is there a way to convert the function to text? Thanks, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy column to another spreadsheet but get value errors
"MoCollins" wrote: I'm trying to copy a column from one spreadsheet to another but because the cells contain functions, I get the #VALUE! error. How can I copy the cells without this happening? Is there a way to convert the function to text? Thanks, Each time you move a cell with formulars, you move the links as well. In your case, by so doing you make excel think within an empty box, hence it returns error! This what you do, copy the column - and paste as values in the new worksheet (right click your mouse, point to paste special, click on values on the left side of the dialogue box and OK). you should be fine now. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy column to another spreadsheet but get value errors
Paste Special/ Values ?
-- David Biddulph "MoCollins" wrote in message ... I'm trying to copy a column from one spreadsheet to another but because the cells contain functions, I get the #VALUE! error. How can I copy the cells without this happening? Is there a way to convert the function to text? Thanks, |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy column to another spreadsheet but get value errors
Thanks, the Paste Special / Value is exactly what I was looking for. Thanks!
"MoCollins" wrote: I'm trying to copy a column from one spreadsheet to another but because the cells contain functions, I get the #VALUE! error. How can I copy the cells without this happening? Is there a way to convert the function to text? Thanks, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to sum a column with errors | Excel Discussion (Misc queries) | |||
| Why does my shared spreadsheet have formula errors? | Excel Worksheet Functions | |||
| copy column and header names from existing spreadsheet to new spre | New Users to Excel | |||
| MAX value of a column that has #div/0 errors in it | Excel Discussion (Misc queries) | |||
| #name? errors on spreadsheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
