Hi Dave,

To replicate it perhaps create a new number format in your custom list that is not included in the template used to open a new sheet.

Unfortunately the code didn't work.

I think the problem with what I am doing is that when the code runs from the macro it opens a new worksheet from a template that doesn't have the format as a custom format.

I have to post the spreadsheet out to many users so I don't think it is practical to get everyone to change their templates.

Still it is strange that when I run the same command from the Excel menu it doesn't lose the formatting...can't quite work that one out.

I wonder if there is some other way I can around it...?


Cheers

Tim