Including number format paste special in the Macro

The likely cause of the problems is that the values in the source ranges are text, not numbers. Check the source carefully. Remember that the formatting of the cells can confuse you.
..::Edit:
Another reason could be that the target cells are formatted as text.

You can also use slightly different code that does not use the clipboard.

Please Login or Register  to view this content.

::..

Artik