| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
When I pastespecialvalue, I get a ' or ^ at the target cell. Why
I created a formular at source cell, such that it shows an empty cell if
there are no values in it: Eg. =IF(D14<"-",COUNTIF(Data!R:R,D14),"") When I copy the source cell, and do a PasteSpecialValue onto a target cell, I get a ' in the target cell, instead of it being blank cell. When I use this on my colleague's excel file, after I do a PasteSpecialValue, the target cell on his pc shows a blank cell and not the '. Why is there a difference and what formatting caused it? I need the target cell to be blank instead of having a '. Many thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 -- Copying a formula to Paste Special into column cell | Excel Discussion (Misc queries) | |||
| Target cell reference moves when target is cut and pasted | Excel Discussion (Misc queries) | |||
| Maintain cell formatting in target cell when using Paste | Excel Discussion (Misc queries) | |||
| Copy and Paste Special (Formulas) pastes cell value if numeric | Excel Discussion (Misc queries) | |||
| Copy Paste Special Link Cell Problem | Links and Linking in Excel | |||
Threaded Mode
