Forum Discussion
Felima65
Jun 23, 2023Copper Contributor
Excel cannot type a horizontal array constant
Hi, this is a very basic question about array constants.
I´m using a brazilian portuguese Corporate Office 365 Excel and I´m studying about static and dynamic arrays. It works just fine when I enter a vertical array contant (just like described in the MS article below) by typing the values in a cell within curly braces separated by semicolons. However, when I do the same trying to create a horizontal array (separated by commas) excel complains there is an error in the formula, no matter if I press Enter or CSE. What am I doing wrong?
Thank you in advance.
5 Replies
Sort By
I guess for your locale it shall be a slash instead of comma
You may check in attached file as well.
- Detlef_LewinSilver Contributor
You were using the en-gb version. Switch to pt-br.
- Felima65Copper ContributorYou're right. Thank you.