| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PASTING FORMAT
HOW TO PASTE CELL LIKE ($100) INTO ONLY NUMBER LIKE 100 ?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
PASTING FORMAT
I think you can do this in 2 ways
1. Use Paste Special--Values 2. Make sure that the Cell foramt of the destination cell is General and not currecncy or custom or number. HTH, -- Pranav Vaidya VBA Developer PN, MH-India If you think my answer is useful, please rate this post as an ANSWER!! "MEHARESH" wrote: HOW TO PASTE CELL LIKE ($100) INTO ONLY NUMBER LIKE 100 ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Losing Original Cell Format when pasting in cells | Excel Discussion (Misc queries) | |||
| Pasting on Filtered Data Sheets without pasting onto hidden cells | Excel Discussion (Misc queries) | |||
| Pasting Format and values | Excel Discussion (Misc queries) | |||
| Format pasting using keyboard shortcuts | Excel Discussion (Misc queries) | |||
| Pasting numbers and formulas without pasting format. | Excel Discussion (Misc queries) | |||
Linear Mode
