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!
|