Make Excel allow numeric fields as text
 

I am generating XML spreadsheets to be opened with Excel. In one cell there
is an employee ID number that is often, but not always, wholly numeric. I
am coding it as

<Cell<Data ss:Type="String"01234567</Data</Cell

and Excel complains that a number is represented as text.

I know the Excel user can turn off this error check, but is there a way I
can handle it at the XML level?


Many thanks!