I have a quick question I hope someone can help me with.
I am using Read Range to read a file into a DataTable.
But when the file has been read into the DataTable it has “converted/changed format” on some of the numbers, as you can see below.
For when I open the file manually in Excel, it has the correct number formatting, as you can see below.
I need to keep the number format after I have read the file into a DataTable (or before i write it back to file), how can I achieve that?