View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kaitlin.uk Kaitlin.uk is offline
external usenet poster
 
Posts: 7
Default helpppppppppppppppp!!!!!!!!!

i save a file from Sage Payroll in csv format to use with my banking
software. this has always run smoothly.
i have saved it in exactly the same way today but it has saved around 50% of
the sort codes as dates e.g sort code 09-06-40 now shows as 09/06/1940 when i
try to format the sort code cells as custom 000000 it comes back with a
figure of 014771????????????? i am baffled.... someone please help!!!!!

thank you!