Write range numercial value

Help
1

I am taking an excel file, adding a column, and re-writing the range back into excel. However, every time it writes back to excel, the numerical format changes. The issue is that these are ID numbers, so the format matters a decent amount.

2

Can you please advise this with a sample ID number which would show the difference between the format of ID number before written to Excel file and after written to excel file.

And also advise what format are you looking for

3

neworiginal

Here is an example of the change. I am wanting for it to return to the original format, but it is changing it to a form of rounding and short hand.

4

The second image is the original format that I would like to have written back in the same format.

5

Have you got the solution for this?