ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Text strings recognized as numbers given different regional settin (https://www.excelbanter.com/excel-programming/309396-text-strings-recognized-numbers-given-different-regional-settin.html)

Anders

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?


All times are GMT +1. The time now is 06:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com