If there are commas where there should be minus signs for subtraction, change them to minus signs. If a cell contains a #VALUE! error, double-click to edit it. However, another list separator might be more appropriate for your particular region. For example, a comma is a common list separator. If the List separator is set to the minus sign, change it to something else. On the Formats tab, click Additional settings. Windows 7: Click Start and then type Region, and then click Region and language. Windows 8: At the Start screen, type Region, click Settings, and then click Region.
Windows 10: Click Start, type Region, and then click the Region control panel.
In Windows, open your Region control panel.
If you don't get the error, try other solutions on this page. If you get the #VALUE! error, go to the next step. The following might solve your problem:įirst do a quick test. If you're using Windows, you might get the #VALUE! error when doing even the most basic subtraction formula.
