I used jdc's suggestion and it worked. However, leading zeros where removed, and I need to keep them. Also, I have to double-click on every individual cell to get the reformatting to take affect. I wanted to be able to make this change globally. Any other help is appreciated. Thanks.