Hello,
I'm using VBA code to copy and paste some data from one sheet to
another. On sheet 1, there are a few cells which are blank. When
they get pasted to sheet 2, the corresponding cells have the following
format:

0.00 0.00 0.00

This is one cell, not three. I have tried to clear formatting, but
this is how it is getting pasted. Any ideas on how to fix this
through VBA?

thanks