| 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. |
| 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 | |||
Threaded Mode
