Hi,

New boy here!

My partner works in payroll in the UK and she regularly needs to export from client received .xls files which contain UK Bank sort codes in the format NN-NN-NN (eg 11-12-46 or similar) Despite formating these fields as text when she converts (saves as) to .csv (required for input to her payroll software) the field is displayed as a date in some cases. So for example 20-42-00 would be OK when converted to .csv but 01-11-56 would be displayed as a date!

I think it must be in the number formatting but I can't work it out.

Has anyone got any ideas for this and apologies if this has been asked before

Best regards,

David