LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Multi-Language Issue - TEXT function

Hi Johnny, question... how can i add a new laguage for my spelling if are not
the default ones?
Thanks,

k

"Johnny" wrote:

Thanks for the advice. When you said the author's name, I remembered
that someone near by had that book on the shelf. I agree: it's a
great round-up of international issues.

Anyway, the author addresses this specific question and provides a
workaround: using the GET.CELL() Excel 4 marco function. He then
warns that sometimes you can get errors.

As I read the chapter, something caught my attention that made me
think of a simpler workaround: all VBA is written in American
English, regardless of the language version of Windows XP and Office
that is installed. So, I simple work a function to wrap the FORMAT
function in VBA. That way, I can guarantee that the string
representing the date will always be formatted based on regional
settings, but using American English inputs. The best of both worlds.

To all:

If you want more info on this, please send me an email
(j~~~~mere~~~~dith AT gm~~~ail.co~~~~m; delete the ~'s of course).
I'm happy to discuss this.

Thanks,
Johnny


 
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
Multi-column sort issue in Pivot Table Mark b. Excel Discussion (Misc queries) 3 February 12th 09 04:47 PM
Multi column sort issue within Pivot table Mark b. Excel Discussion (Misc queries) 0 February 11th 09 02:56 PM
List Box - Multi Select Issue Joe Wildman[_2_] Excel Worksheet Functions 2 February 6th 09 12:00 AM
Add-in function - language Johannes Excel Worksheet Functions 3 October 25th 06 11:44 PM
Date function/Text issue MijC Excel Worksheet Functions 10 December 6th 05 09:34 PM


All times are GMT +1. The time now is 06:38 AM.

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

About Us

"It's about Microsoft Excel"