Excel Format of cell

[Johanmbreytenbach]

My Excel 365 displays all Numbers entered into cells as Text and I cannot change that 

[#2]

@Johanmbreytenbach 

Please check if cells are not formatted as text and Show Formulas is switched off

[#3]

Hi Sergei, Cell formatted as number and Show Formulas switched off. The ISTEXT() function still returns a yes and I can not perform calculations on the cell/s.

[#4]

@Johanmbreytenbach 

Is that on any file or on some specific one? Perhaps you may share sample file with such formatting?

[#5]

Sergei I figured it out. Goto File, Options, Advanced and go down to System Separators and unmark. Now change the Decimal Separator to a . and the Thousands Separator to a , (comma) and then Mark or Tick the System Separators again. When entering Numbers use the decimal . and the system will recognize the input as a Number. Thanx

[#6]

@Johanmbreytenbach 

I see, thank you for the update. You may change default regional settings for your Windows as well.