| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.office.xml
|
|||
|
|||
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concantenate numeric fields | Excel Worksheet Functions | |||
| Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
| Is it possible to make excel NOT process non-numeric cell data in formulae | Excel Discussion (Misc queries) | |||
| How do I take some of my Excel fields and make address labels? | Excel Discussion (Misc queries) | |||
| Assigning text values to numeric fields | Excel Discussion (Misc queries) | |||
Hybrid Mode
