LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default Regional Settings / Finding out Array separator characters

Hello !

I'm running Excel on a Portuguese Windows XP system.

I'm trying to create some array constants but haven't been able to do
it.

As for VERTICAL arrays, I use the ";" (semicolons) and it works fine,
like this : ={"A";"B";"C"}

However, when I try to create a HORIZONTAL array, I try to use the
"," (commas) as separators but I can't even enter the formula. It
complains.

How do I find out WHICH is the Array separator character in this
case ?

Notice that in Portuguese, Decimal point is comma.

Thanks !
 
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
Regional settings Ana via OfficeKB.com Excel Worksheet Functions 1 October 27th 09 02:41 PM
regional settings Spike Excel Worksheet Functions 5 July 29th 07 01:10 AM
Regional settings independent list separator in arrays Vlado Sveda Excel Worksheet Functions 3 January 9th 07 01:19 PM
TAB as list separator via regional setting Udo Excel Discussion (Misc queries) 0 November 8th 06 09:09 PM
Regional Settings LAF Excel Discussion (Misc queries) 2 July 30th 05 12:51 PM


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