ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Problems with Excel Horizontal arrays with regional options using. (https://www.excelbanter.com/excel-discussion-misc-queries/3180-problems-excel-horizontal-arrays-regional-options-using.html)

Dr. Strangelove

Problems with Excel Horizontal arrays with regional options using.
 
Entering a vertical array ={10;20} works ok, but horizontal array ={10,20}
gives 10,2 ;-) in both cells instead of 10 and 20 in the two cells.

This happens, I presume, because I work with a comma as decimal separator
and NOT with the American .
I do suppose that Excel has got some solution for this behaviour.
I, in principle, do NOT want to change the regional options.


All times are GMT +1. The time now is 12:09 AM.

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