View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AJ
 
Posts: n/a
Default Is there an equivalent of Lotus 123's "Paste visible" command?

The only inherently annoying thing I have found about Excel is that I can't
find an equivalent to Lotus 123's "Paste Visible" command. Does anyone know
if Excel has an equivalent.

To illustrate:

A cell may have a value of "73.4563" but be formatted to display "73", ie
"73" is all that is visible. I want to be able to copy that cell and, when I
paste it, for the target cell to have a value of "73", not the previous value
of "73.4563".

As an aside, does 123 still exist?