LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 8th 04, 11:03 PM posted to microsoft.public.excel.programming
external usenet poster
First recorded activity by ExcelBanter: Aug 2006
Posts: 54
Default 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?

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
find and replace numeric strings in larger text strings Mr Molio Excel Worksheet Functions 8 November 9th 11 05:17 PM
Add text automatically by recognized value Peter Gonzalez[_2_] Excel Worksheet Functions 4 April 16th 10 09:21 PM
2 more questions about extracting numbers from text strings andy from maine Excel Discussion (Misc queries) 0 March 28th 05 09:47 PM
how to format numbers, digit grouping ,as per regional settings Mayank Excel Discussion (Misc queries) 3 December 31st 04 04:45 AM
ADO inserts text strings not numbers when table is empty Rob Nicholson Excel Programming 5 March 5th 04 06:10 PM

All times are GMT +1. The time now is 08:40 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017