I am working on Excel sheet (Excel 2007), changing a Numeric field to Text. FYI, a VBA macro attached to the sheet. When I run the macro, immediately the Text field changes to Numeric and the value in it becomes number. For example, 23Jan10 changes to 40201.00. I keep changing the field to a Text, but changes to Numeric soon after I run the macro. Please let me know if I am not clear on my question. Thank you in advance.