I want to copy numbers from a row from one sheet to another without the cell formatting.
Hello,
- Copy as usual (
CTRL+C
) -
Edit -> Paste -> Paste Special -> Paste Special...
(or useCTRL+SHIFT+V
) and select what you want to insert by setting the proper options (see screenshot) - Click
OK
You may also use this alternative procedure:
- Copy as usual (
CTRL+C
) - Move to target sheet and cell
-
Rightclick -> Paste Special -> Number
(or whatever type your data is)
Hope that helps
that’s great and it worked. thanks so much! Wished I would have found this site sooner…
If it is helpful please consider to click the check mark () next to the answer. Thanks in advance …