Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text strings recognized as numbers given different regional settin
We have a vb application which allows the user to export exhibits to excel.
The exhibits are displayed as text strings on a Flexgrid and subsequently exported to excel. How should numbers be formated before being displayed on the flexgrid such that excel will recognize them as numbers regardless of the regional settings? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find and replace numeric strings in larger text strings | Excel Worksheet Functions | |||
Add text automatically by recognized value | Excel Worksheet Functions | |||
2 more questions about extracting numbers from text strings | Excel Discussion (Misc queries) | |||
how to format numbers, digit grouping ,as per regional settings | Excel Discussion (Misc queries) | |||
ADO inserts text strings not numbers when table is empty | Excel Programming |