Hi my client has an excel file MAIN (for eg) that shall be updated with values generated from another system in a excel format (temp).

the client copies the data from the temp file and paste it in the Main file.
issue: the main file has a formatting of 0.0000000000.
Whereas the temp file does not have a standard formatting.

When the client pastes the values, the formatting gets changed.

Is there any possibility that the we retain the formatting of a column, when i do the above functionality.

Regards
Suku