I have a program I have written in VBA on top of excel that uses forms, and I have embedded an excel spreadsheet from the office web components toolkit in the form. I am having a problem where something like '1-16' being entered triggers the auto-formatting and gets converted to '16 Jan'. I tried to change the formatting of the cells, but instead of giving you a 'format' option, it only gives you a 'number format' option; there is no way to format the cells as text. I was wondering if there is some property or a way of disabling this annoying formatting in code? I know that you can precede things by an apostrophe to prevent this, but it's really not practical in my situation.