Forum Discussion
Solved
Formula error & calc problem
Finally found somewhere I can turn to for help – I'm disabled and stuck at home so have no one to ask help from, only the dog and he's not very good with Excel. in example 1 below trying to total a ...
- Excel does not recognize your numbers as being numbers. Also, it looks like your regional settings are off. Perhaps best to do this:
- Close Excel
- Open control panel, Language and region
- Switch to any country other than yours
- OK your way out
- Open control panel, Language and region again
- Select your own country.
Excel does not recognize your numbers as being numbers. Also, it looks like your regional settings are off. Perhaps best to do this:
- Close Excel
- Open control panel, Language and region
- Switch to any country other than yours
- OK your way out
- Open control panel, Language and region again
- Select your own country.
- Close Excel
- Open control panel, Language and region
- Switch to any country other than yours
- OK your way out
- Open control panel, Language and region again
- Select your own country.
JKPieterse wrote:
Excel does not recognize your numbers as being numbers. Also, it looks like your regional settings are off. Perhaps best to do this:
- Close Excel
- Open control panel, Language and region
- Switch to any country other than yours
- OK your way out
- Open control panel, Language and region again
- Select your own country.I set any countries setting to another country
did a reboot
set all country settings back to UK
did a reboot
Don't know if I followed your instructions correctly but it seems to have done the trick, thank you very much.
- Outstanding!
- Can't thank you enough! Been going round in circles with this for months.
