Forum Discussion
Solved
Index & Match Errors + warning Signs
Excel is not allowing me to add C5:C7 after the first comma of my formula, see error image that appears. Any help would be appreciated as im using another computer to work as this fails.
JonTektos Perhaps the link below helps. You need to change the regional number formats in Windows.
You probably have a comma as the decimal symbol, a point as the digit grouping symbol and a semi-column as the list separator. Change that the point, comma, comma respectively.
Thank you, but I just want to use the comma and have no idea why a simple formula cannot be carried out.
How can i revert this odd setting.
How can i revert this odd setting.
JonTektos Perhaps the link below helps. You need to change the regional number formats in Windows.
You probably have a comma as the decimal symbol, a point as the digit grouping symbol and a semi-column as the list separator. Change that the point, comma, comma respectively.
Riny_van_Eekelen Your a star IT support set up the machine in Hong Kong both language & region hence the ;
Now reverted back to english all sorted thank you