Repeat this process for other columns to ensure they don't contain leading spaces before dates.Įxcel uses your computer's date system. Choose a date format, and then click Finish. On Step 3 of 3 of the wizard, under Column data format, click Date. Select the column that contains the date by clicking its column header. If you don't see one or more spaces, go to the next section on checking your computer's date settings. If your cell has this problem, proceed to the next step. Here's what a selected space looks like at the beginning of a cell: Put your cursor at the beginning and see if you can select one or more spaces. Double-click a date that is being used in a subtraction formula. Here are some solutions that can help this problem. And Excel won't recognize text as a date. But if it's aligned to the left, this means the date isn't really a date. If your date is aligned to the right, then it's a date. #VALUE! error subtracting dates stored as text Make your date column wider. 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, 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.
#VALUE! with basic subtraction If you're using Windows, you might get the #VALUE! error when doing even the most basic subtraction formula.
0 kommentar(er)
