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