Problems with Excel Horizontal arrays with regional options using.

  • Thread starter Dr. Strangelove
  • Start date
D

Dr. Strangelove

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top