Paste using enter key no longer available

Occasional Visitor

So I've run into a fairly basic shortcut issue that is quite annoying and bothersome and have not been able to resolve.


When working in excel, I will copy a number calculated from a formula, and go to paste the value in a different workbook.  (Ctrl+C) [this works properly as I see the dotted lines] and then paste with (Ctrl+V).  


Initially the past works properly as I see the value paste, but a second later the value changes to a dash as the value changes to the copied formula.


The same happens if I use the (menu key +V+Enter)


What can I do to get my value paste back?

The Ctrl+Alt+V does work, but this is a pain for me as I am not efficient with this process.


Kind Regards,



1 Reply
Right hand mouse click and paste values