| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error with copying values in cells
I'm having difficulty copying and pasting values only, using the 'paste
special' option. The values are incorrect. I've verified that the cells are not formatted as text, but numbers instead. Also, after pasting the copied cells, the sum function changes, even though I do not select that cell or change its contents in any way that I can see. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Error with copying values in cells
Check whether the cells you copied are formatted to display differently..
If this post helps click Yes --------------- Jacob Skaria "SabrinaB" wrote: I'm having difficulty copying and pasting values only, using the 'paste special' option. The values are incorrect. I've verified that the cells are not formatted as text, but numbers instead. Also, after pasting the copied cells, the sum function changes, even though I do not select that cell or change its contents in any way that I can see. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Error with copying values in cells
Thanks, it looks like it was an issue between different versions of excel.
"Jacob Skaria" wrote: Check whether the cells you copied are formatted to display differently.. If this post helps click Yes --------------- Jacob Skaria "SabrinaB" wrote: I'm having difficulty copying and pasting values only, using the 'paste special' option. The values are incorrect. I've verified that the cells are not formatted as text, but numbers instead. Also, after pasting the copied cells, the sum function changes, even though I do not select that cell or change its contents in any way that I can see. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Get error message about copying cells with more than 255 characte. | Excel Worksheet Functions | |||
| cells without values causing error message | Excel Discussion (Misc queries) | |||
| Hiding error values in cells | Excel Worksheet Functions | |||
| Copying cells with similar column values | New Users to Excel | |||
| Copying values but skipping empty cells | Excel Worksheet Functions | |||
Linear Mode
