Mike,
Thanks for the response. This worked, I also had to format the number column as text so I could get "01" to show up rather than "1". I did create two new columns so I wouldn't loose my original column as I have cells pointing to these to pull data. I can now just hide these two new columns so it looks good.
Thanks again, Stephen