Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pasting "as displayed" formatted cell contents
I have formatted cells as follows "CN"00000000"S10" so that when I type in a
serial number such as 12345678 it appears in the cell as CN12345678S10. How can I copy the contents as it appears in the the formatted cell and paste the "as displayed value" into another cell without formatting the destination cell? In effect pasting the value CN12345678S10 into another cell. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pasting "as displayed" formatted cell contents
Try
Edit|Pastespecial select ALL OK Mike "jimqual7" wrote: I have formatted cells as follows "CN"00000000"S10" so that when I type in a serial number such as 12345678 it appears in the cell as CN12345678S10. How can I copy the contents as it appears in the the formatted cell and paste the "as displayed value" into another cell without formatting the destination cell? In effect pasting the value CN12345678S10 into another cell. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pasting "as displayed" formatted cell contents
nope, that doesn't work
"Mike H" wrote: Try Edit|Pastespecial select ALL OK Mike "jimqual7" wrote: I have formatted cells as follows "CN"00000000"S10" so that when I type in a serial number such as 12345678 it appears in the cell as CN12345678S10. How can I copy the contents as it appears in the the formatted cell and paste the "as displayed value" into another cell without formatting the destination cell? In effect pasting the value CN12345678S10 into another cell. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pasting "as displayed" formatted cell contents
There is no silver bullet on that one. What is actually stored is 12345678 so
that is what is copied. The CN and S10 are just formatting. Short of copying the cell formatting where the extra characters are stored you are hooped... -- HTH... Jim Thomlinson "jimqual7" wrote: nope, that doesn't work "Mike H" wrote: Try Edit|Pastespecial select ALL OK Mike "jimqual7" wrote: I have formatted cells as follows "CN"00000000"S10" so that when I type in a serial number such as 12345678 it appears in the cell as CN12345678S10. How can I copy the contents as it appears in the the formatted cell and paste the "as displayed value" into another cell without formatting the destination cell? In effect pasting the value CN12345678S10 into another cell. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pasting "as displayed" formatted cell contents
Mike's suggestion worked fine for me.
It didn't change the underlying value, but by paste special|all, both the value and the numberformat were pasted. So the text displayed the same thing. What didn't work for you? jimqual7 wrote: nope, that doesn't work "Mike H" wrote: Try Edit|Pastespecial select ALL OK Mike "jimqual7" wrote: I have formatted cells as follows "CN"00000000"S10" so that when I type in a serial number such as 12345678 it appears in the cell as CN12345678S10. How can I copy the contents as it appears in the the formatted cell and paste the "as displayed value" into another cell without formatting the destination cell? In effect pasting the value CN12345678S10 into another cell. -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pasting "as displayed" formatted cell contents
I clicked on a formatted cell chose a blank cell and pasted "all". it pasted
only the numerica and not the formatting. "Dave Peterson" wrote: Mike's suggestion worked fine for me. It didn't change the underlying value, but by paste special|all, both the value and the numberformat were pasted. So the text displayed the same thing. What didn't work for you? jimqual7 wrote: nope, that doesn't work "Mike H" wrote: Try Edit|Pastespecial select ALL OK Mike "jimqual7" wrote: I have formatted cells as follows "CN"00000000"S10" so that when I type in a serial number such as 12345678 it appears in the cell as CN12345678S10. How can I copy the contents as it appears in the the formatted cell and paste the "as displayed value" into another cell without formatting the destination cell? In effect pasting the value CN12345678S10 into another cell. -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pasting "as displayed" formatted cell contents
I could do a plain old copy|paste and all the formatting--including the number
formatting--got carried over. I'm not sure why it doesn't work for you. jimqual7 wrote: I clicked on a formatted cell chose a blank cell and pasted "all". it pasted only the numerica and not the formatting. "Dave Peterson" wrote: Mike's suggestion worked fine for me. It didn't change the underlying value, but by paste special|all, both the value and the numberformat were pasted. So the text displayed the same thing. What didn't work for you? jimqual7 wrote: nope, that doesn't work "Mike H" wrote: Try Edit|Pastespecial select ALL OK Mike "jimqual7" wrote: I have formatted cells as follows "CN"00000000"S10" so that when I type in a serial number such as 12345678 it appears in the cell as CN12345678S10. How can I copy the contents as it appears in the the formatted cell and paste the "as displayed value" into another cell without formatting the destination cell? In effect pasting the value CN12345678S10 into another cell. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
how to increase size of "name box" and "contents of cell " displa. | New Users to Excel | |||
In Excel a cell formatted "currency" shows "######" help! | Excel Worksheet Functions | |||
cells formatted to tick when text value "Y" if or null if "N" | Excel Discussion (Misc queries) | |||
if one cell has "X" textin contents, then pull cell "Y"... | Excel Worksheet Functions |