I have a macro that is picking up from a list on a seperate worksheets a bank
sort code being

12-34-56

The macro is then putting this code into another worksheet. But in the
worksheet the code is being put into the format keeps changing itself to
date. I have tried changing it to text and saving it but when the macro is
run the format changes to date and the code is no good.

Is this something within the settings such as auto correct or options that
is causing this to happen?

thanks in advance
Hervinder