Trying to import employee details into a new Sage payroll company. Template is a csv file. The data has been exported from an existing sage payroll company into a csv file. Some employee bank sort codes are defaulting to date format and not the sort code format required ie sort code 09-01-28 (format required), insists on saving as 09/01/2028, whereas sort code 01-67-14 is saving in the correct format because it doesn't look anything like a date. Tried converting 09-01-28 to a text field by putting a ' infront of it, but each time I save the data as a csv file it loses the new formatting and reverts to the date format. The data won't import into Sage payroll because of the dates. Does anyone know a way round this?
Many thanks
Replies (1)
Please login or register to join the discussion.
This
link has some tips for importing sort codes which may be of help: https://my.sage.co.uk/public/help/askarticle.aspx?articleid=30184