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?
|