View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.office.xml
Michael A. Covington Michael A. Covington is offline
external usenet poster
 
Posts: 1
Default 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!