software

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

To illustrate:

A cell may have a value of quot;73.4563quot; but be formatted to display quot;73quot;, ie
quot;73quot; 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 quot;73quot;, not the previous value
of quot;73.4563quot;.

As an aside, does 123 still exist?

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

quot;AJquot; gt; wrote in message
...
gt; The only inherently annoying thing I have found about Excel is that I
gt; can't
gt; find an equivalent to Lotus 123's quot;Paste Visiblequot; command. Does anyone
gt; know
gt; if Excel has an equivalent.
gt;
gt; To illustrate:
gt;
gt; A cell may have a value of quot;73.4563quot; but be formatted to display quot;73quot;, ie
gt; quot;73quot; is all that is visible. I want to be able to copy that cell and, when
gt; I
gt; paste it, for the target cell to have a value of quot;73quot;, not the previous
gt; value
gt; of quot;73.4563quot;.
gt;
gt; As an aside, does 123 still exist?
Hi

Thank you for the suggestion.

I tried that and the pasted cell copies the format (or appearance) of the
copied cell but the underlying cell value remains the same.

I am after a way of copying a cell so that the appearance of a copied cell
(eg. quot;52quot; appears on screen when it has an underlying value of quot;52.343quot;),
becomes the underlying value in the target cell (so when you click on the
target cell, quot;52quot; appears both in the cell and in the formula bar).

Any ideas?

Alan.quot;Mike Middletonquot; wrote:

gt; AJ -
gt;
gt; In Excel 2003 (and perhaps in other recent versions of Excel), choose Edit |
gt; Copy.
gt;
gt; Select another cell, and choose Edit | Paste Special | Formulas And Number
gt; Formats (or Values And Number Formats).
gt;
gt; - Mike
gt; www.mikemiddleton.com
gt;
gt; quot;AJquot; gt; wrote in message
gt; ...
gt; gt; The only inherently annoying thing I have found about Excel is that I
gt; gt; can't
gt; gt; find an equivalent to Lotus 123's quot;Paste Visiblequot; command. Does anyone
gt; gt; know
gt; gt; if Excel has an equivalent.
gt; gt;
gt; gt; To illustrate:
gt; gt;
gt; gt; A cell may have a value of quot;73.4563quot; but be formatted to display quot;73quot;, ie
gt; gt; quot;73quot; is all that is visible. I want to be able to copy that cell and, when
gt; gt; I
gt; gt; paste it, for the target cell to have a value of quot;73quot;, not the previous
gt; gt; value
gt; gt; of quot;73.4563quot;.
gt; gt;
gt; gt; As an aside, does 123 still exist?
gt;
gt;
gt;

in excel2002 when you copy pastespecial-valuaes a smalrt tag comes us where
in you can choose quot;keep source formattingquot;AJquot; gt; wrote in message
...
gt; Hi
gt;
gt; Thank you for the suggestion.
gt;
gt; I tried that and the pasted cell copies the format (or appearance) of the
gt; copied cell but the underlying cell value remains the same.
gt;
gt; I am after a way of copying a cell so that the appearance of a copied cell
gt; (eg. quot;52quot; appears on screen when it has an underlying value of quot;52.343quot;),
gt; becomes the underlying value in the target cell (so when you click on the
gt; target cell, quot;52quot; appears both in the cell and in the formula bar).
gt;
gt; Any ideas?
gt;
gt; Alan.
gt;
gt;
gt; quot;Mike Middletonquot; wrote:
gt;
gt;gt; AJ -
gt;gt;
gt;gt; In Excel 2003 (and perhaps in other recent versions of Excel), choose
gt;gt; Edit |
gt;gt; Copy.
gt;gt;
gt;gt; Select another cell, and choose Edit | Paste Special | Formulas And
gt;gt; Number
gt;gt; Formats (or Values And Number Formats).
gt;gt;
gt;gt; - Mike
gt;gt; www.mikemiddleton.com
gt;gt;
gt;gt; quot;AJquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; The only inherently annoying thing I have found about Excel is that I
gt;gt; gt; can't
gt;gt; gt; find an equivalent to Lotus 123's quot;Paste Visiblequot; command. Does anyone
gt;gt; gt; know
gt;gt; gt; if Excel has an equivalent.
gt;gt; gt;
gt;gt; gt; To illustrate:
gt;gt; gt;
gt;gt; gt; A cell may have a value of quot;73.4563quot; but be formatted to display quot;73quot;,
gt;gt; gt; ie
gt;gt; gt; quot;73quot; is all that is visible. I want to be able to copy that cell and,
gt;gt; gt; when
gt;gt; gt; I
gt;gt; gt; paste it, for the target cell to have a value of quot;73quot;, not the previous
gt;gt; gt; value
gt;gt; gt; of quot;73.4563quot;.
gt;gt; gt;
gt;gt; gt; As an aside, does 123 still exist?
gt;gt;
gt;gt;
gt;gt;
that is a very useful function that I didn't know about, thank you.

Nonetheless, the underlying cell value in the pasted cell remains the same.
Lotus 123's ability to alter the underlying cell value was a highly useful
feature and I haven't found a quick way of doing this in excel.

Do you think we have to say this functionality does not exist in Excel? If
so, does anyone know if there is an official wish list forum for Excel?

Thanks

Alan.

quot;R..VENKATARAMANquot; wrote:

gt; in excel2002 when you copy pastespecial-valuaes a smalrt tag comes us where
gt; in you can choose quot;keep source formatting
gt;
gt;
gt; quot;AJquot; gt; wrote in message
gt; ...
gt; gt; Hi
gt; gt;
gt; gt; Thank you for the suggestion.
gt; gt;
gt; gt; I tried that and the pasted cell copies the format (or appearance) of the
gt; gt; copied cell but the underlying cell value remains the same.
gt; gt;
gt; gt; I am after a way of copying a cell so that the appearance of a copied cell
gt; gt; (eg. quot;52quot; appears on screen when it has an underlying value of quot;52.343quot;),
gt; gt; becomes the underlying value in the target cell (so when you click on the
gt; gt; target cell, quot;52quot; appears both in the cell and in the formula bar).
gt; gt;
gt; gt; Any ideas?
gt; gt;
gt; gt; Alan.
gt; gt;
gt; gt;
gt; gt; quot;Mike Middletonquot; wrote:
gt; gt;
gt; gt;gt; AJ -
gt; gt;gt;
gt; gt;gt; In Excel 2003 (and perhaps in other recent versions of Excel), choose
gt; gt;gt; Edit |
gt; gt;gt; Copy.
gt; gt;gt;
gt; gt;gt; Select another cell, and choose Edit | Paste Special | Formulas And
gt; gt;gt; Number
gt; gt;gt; Formats (or Values And Number Formats).
gt; gt;gt;
gt; gt;gt; - Mike
gt; gt;gt; www.mikemiddleton.com
gt; gt;gt;
gt; gt;gt; quot;AJquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; The only inherently annoying thing I have found about Excel is that I
gt; gt;gt; gt; can't
gt; gt;gt; gt; find an equivalent to Lotus 123's quot;Paste Visiblequot; command. Does anyone
gt; gt;gt; gt; know
gt; gt;gt; gt; if Excel has an equivalent.
gt; gt;gt; gt;
gt; gt;gt; gt; To illustrate:
gt; gt;gt; gt;
gt; gt;gt; gt; A cell may have a value of quot;73.4563quot; but be formatted to display quot;73quot;,
gt; gt;gt; gt; ie
gt; gt;gt; gt; quot;73quot; is all that is visible. I want to be able to copy that cell and,
gt; gt;gt; gt; when
gt; gt;gt; gt; I
gt; gt;gt; gt; paste it, for the target cell to have a value of quot;73quot;, not the previous
gt; gt;gt; gt; value
gt; gt;gt; gt; of quot;73.4563quot;.
gt; gt;gt; gt;
gt; gt;gt; gt; As an aside, does 123 still exist?
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

If you don't want the value pasted and don't want the formula pasted, I'm
confused as to exactly what you are wanting to copy...

quot;AJquot; wrote:

gt; that is a very useful function that I didn't know about, thank you.
gt;
gt; Nonetheless, the underlying cell value in the pasted cell remains the same.
gt; Lotus 123's ability to alter the underlying cell value was a highly useful
gt; feature and I haven't found a quick way of doing this in excel.
gt;
gt; Do you think we have to say this functionality does not exist in Excel? If
gt; so, does anyone know if there is an official wish list forum for Excel?
gt;
gt; Thanks
gt;
gt; Alan.
gt;
gt; quot;R..VENKATARAMANquot; wrote:
gt;
gt; gt; in excel2002 when you copy pastespecial-valuaes a smalrt tag comes us where
gt; gt; in you can choose quot;keep source formatting
gt; gt;
gt; gt;
gt; gt; quot;AJquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Hi
gt; gt; gt;
gt; gt; gt; Thank you for the suggestion.
gt; gt; gt;
gt; gt; gt; I tried that and the pasted cell copies the format (or appearance) of the
gt; gt; gt; copied cell but the underlying cell value remains the same.
gt; gt; gt;
gt; gt; gt; I am after a way of copying a cell so that the appearance of a copied cell
gt; gt; gt; (eg. quot;52quot; appears on screen when it has an underlying value of quot;52.343quot;),
gt; gt; gt; becomes the underlying value in the target cell (so when you click on the
gt; gt; gt; target cell, quot;52quot; appears both in the cell and in the formula bar).
gt; gt; gt;
gt; gt; gt; Any ideas?
gt; gt; gt;
gt; gt; gt; Alan.
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Mike Middletonquot; wrote:
gt; gt; gt;
gt; gt; gt;gt; AJ -
gt; gt; gt;gt;
gt; gt; gt;gt; In Excel 2003 (and perhaps in other recent versions of Excel), choose
gt; gt; gt;gt; Edit |
gt; gt; gt;gt; Copy.
gt; gt; gt;gt;
gt; gt; gt;gt; Select another cell, and choose Edit | Paste Special | Formulas And
gt; gt; gt;gt; Number
gt; gt; gt;gt; Formats (or Values And Number Formats).
gt; gt; gt;gt;
gt; gt; gt;gt; - Mike
gt; gt; gt;gt; www.mikemiddleton.com
gt; gt; gt;gt;
gt; gt; gt;gt; quot;AJquot; gt; wrote in message
gt; gt; gt;gt; ...
gt; gt; gt;gt; gt; The only inherently annoying thing I have found about Excel is that I
gt; gt; gt;gt; gt; can't
gt; gt; gt;gt; gt; find an equivalent to Lotus 123's quot;Paste Visiblequot; command. Does anyone
gt; gt; gt;gt; gt; know
gt; gt; gt;gt; gt; if Excel has an equivalent.
gt; gt; gt;gt; gt;
gt; gt; gt;gt; gt; To illustrate:
gt; gt; gt;gt; gt;
gt; gt; gt;gt; gt; A cell may have a value of quot;73.4563quot; but be formatted to display quot;73quot;,
gt; gt; gt;gt; gt; ie
gt; gt; gt;gt; gt; quot;73quot; is all that is visible. I want to be able to copy that cell and,
gt; gt; gt;gt; gt; when
gt; gt; gt;gt; gt; I
gt; gt; gt;gt; gt; paste it, for the target cell to have a value of quot;73quot;, not the previous
gt; gt; gt;gt; gt; value
gt; gt; gt;gt; gt; of quot;73.4563quot;.
gt; gt; gt;gt; gt;
gt; gt; gt;gt; gt; As an aside, does 123 still exist?
gt; gt; gt;gt;
gt; gt; gt;gt;
gt; gt; gt;gt;
gt; gt;
gt; gt;
gt; gt;

I am wanting to copy the value of a cell as it appears, not its underlying
value.

So, if a cell containing the value 15.65 is formatted to display quot;15quot;, I
want to be able to paste the value quot;15quot;.

Does this explanation help?

Alan.

quot;Carole Drakequot; wrote:

gt; If you don't want the value pasted and don't want the formula pasted, I'm
gt; confused as to exactly what you are wanting to copy...
gt;
gt; quot;AJquot; wrote:
gt;
gt; gt; that is a very useful function that I didn't know about, thank you.
gt; gt;
gt; gt; Nonetheless, the underlying cell value in the pasted cell remains the same.
gt; gt; Lotus 123's ability to alter the underlying cell value was a highly useful
gt; gt; feature and I haven't found a quick way of doing this in excel.
gt; gt;
gt; gt; Do you think we have to say this functionality does not exist in Excel? If
gt; gt; so, does anyone know if there is an official wish list forum for Excel?
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt; Alan.
gt; gt;
gt; gt; quot;R..VENKATARAMANquot; wrote:
gt; gt;
gt; gt; gt; in excel2002 when you copy pastespecial-valuaes a smalrt tag comes us where
gt; gt; gt; in you can choose quot;keep source formatting
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;AJquot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt; Hi
gt; gt; gt; gt;
gt; gt; gt; gt; Thank you for the suggestion.
gt; gt; gt; gt;
gt; gt; gt; gt; I tried that and the pasted cell copies the format (or appearance) of the
gt; gt; gt; gt; copied cell but the underlying cell value remains the same.
gt; gt; gt; gt;
gt; gt; gt; gt; I am after a way of copying a cell so that the appearance of a copied cell
gt; gt; gt; gt; (eg. quot;52quot; appears on screen when it has an underlying value of quot;52.343quot;),
gt; gt; gt; gt; becomes the underlying value in the target cell (so when you click on the
gt; gt; gt; gt; target cell, quot;52quot; appears both in the cell and in the formula bar).
gt; gt; gt; gt;
gt; gt; gt; gt; Any ideas?
gt; gt; gt; gt;
gt; gt; gt; gt; Alan.
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Mike Middletonquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt;gt; AJ -
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt; In Excel 2003 (and perhaps in other recent versions of Excel), choose
gt; gt; gt; gt;gt; Edit |
gt; gt; gt; gt;gt; Copy.
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt; Select another cell, and choose Edit | Paste Special | Formulas And
gt; gt; gt; gt;gt; Number
gt; gt; gt; gt;gt; Formats (or Values And Number Formats).
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt; - Mike
gt; gt; gt; gt;gt; www.mikemiddleton.com
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt; quot;AJquot; gt; wrote in message
gt; gt; gt; gt;gt; ...
gt; gt; gt; gt;gt; gt; The only inherently annoying thing I have found about Excel is that I
gt; gt; gt; gt;gt; gt; can't
gt; gt; gt; gt;gt; gt; find an equivalent to Lotus 123's quot;Paste Visiblequot; command. Does anyone
gt; gt; gt; gt;gt; gt; know
gt; gt; gt; gt;gt; gt; if Excel has an equivalent.
gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt;gt; gt; To illustrate:
gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt;gt; gt; A cell may have a value of quot;73.4563quot; but be formatted to display quot;73quot;,
gt; gt; gt; gt;gt; gt; ie
gt; gt; gt; gt;gt; gt; quot;73quot; is all that is visible. I want to be able to copy that cell and,
gt; gt; gt; gt;gt; gt; when
gt; gt; gt; gt;gt; gt; I
gt; gt; gt; gt;gt; gt; paste it, for the target cell to have a value of quot;73quot;, not the previous
gt; gt; gt; gt;gt; gt; value
gt; gt; gt; gt;gt; gt; of quot;73.4563quot;.
gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt;gt; gt; As an aside, does 123 still exist?
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;