Thank you for looking at my question,
I am using VBA to extract inventory data from a large (468400 lines 42,144kb) csv file clean it up and write it to a .xlsx worksheet (9500 lines, 2,100KB)
Many of the part numbers in the file are all numeric characters. After the process finished I opened the .xlsx file and found that the all-numeric part numbers have been processed as if they were numbers (aligned to the right of the column) in a left-aligned column of predominantly text values. Some large numbers have even been output in standard form / scientific notation eg
100175264000499000 is in the worksheet as 1.00175E+17 - this is a real pain because
100175268910209000 is also shown as 1.00175E+17
Can anybody tell me how to force Excel to handle the strings of numbers as strings and not numbers please?