Forum Discussion
Excel Formatting UK Sort Code to Date Automatically
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 aut...
Excel is great for importing CSV's and crunching the data inside, but it isn't a very good app for editing CSV files, I recommend having a look at a dedicated CSV file editor. There's a list here: https://listoffreeware.com/list-of-best-free-csv-editor-software-for-windows/