AJ -

In Excel 2003 (and perhaps in other recent versions of Excel), choose Edit |
Copy.

Select another cell, and choose Edit | Paste Special | Formulas And Number
Formats (or Values And Number Formats).

- Mike
www.mikemiddleton.com

"AJ" wrote in message
...
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?