Reply
 
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?

Reply
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 06: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 05:45 AM
ADO inserts text strings not numbers when table is empty Rob Nicholson Excel Programming 5 March 5th 04 07:10 PM


All times are GMT +1. The time now is 06:06 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