Dec 10 2019 03:35 AM
Hello,
I am currently trying to format a CSV that contains UK Sort Codes (in the format of 01-02-03) in order to send to payroll. For some reason, when we input the sort code into the CSV, it automatically formats it into a date (01/02/2003 - UK Date Format).
I have tried to add an apostrophe in front of it (ie input cell as '01-02-03) which does format the cell correctly, however when i save and reopen the CSV, it goes back to date.
Does anyone know a solution to this? Cheers
Dec 10 2019 05:07 AM