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 …