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

Check and see if in your macro there is a format being called out ( then
just change it )
If not, you can add this to your macro

( this one formats ALL the cells in the sheet to "General"


Cells.Select
Selection.NumberFormat = "General"

"Hervinder" wrote:

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

You can d
"Hervinder" wrote in message
...
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