Repeat this process for other cells that have the error. 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, select Additional settings. Windows 7: Select Start, type Region, and then select Region and language. Windows 8: At the Start screen, type Region, select Settings, and then select Region. Windows 10: Select Start, type Region, and then select 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |