Values in excel not updating
If you are confident that all spaces in the column should be removed, click Replace All. error then hopefully your error has been replaced by the formula result, as shown here in our example. If you see this problem, we recommend converting numbers stored as text to numbers. error with something else like your own text, a zero or a blank cell.This quick fix can save you from the tedium of re-entering thousands of rows of data.When entering numerical data in Excel, it helps to format it according to the type of data it is. percentage, currency, date, or text—helps drive consistency and accuracy in displaying and working with your data.#VALUE is Excel's way of saying, "There's something wrong with the way your formula is typed.
Or, there's something wrong with the cells you are referencing." The error is very general, and it can be hard to find the exact cause of it.
Please notice that it is written with an assumption that the text date has two characters for days, two characters for months, and four characters for year.