Or, in Excel you could create a new column and use the DATE function to create a true date based on the date stored as text.

Here's how to do that assuming your computers date system is mm/dd/yyy and your text date is 31/12/2017 in cell A1: Note: The formula above is written with the DATE, RIGHT, MID, and LEFT functions.

values in excel not updating-72

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.

You may need to customize the formula to suit your date.

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.

Find cells that your formula is referencing and select them.

In many cases removing spaces for an entire column is a good practice because you can replace more than one space at a time.

If you know from the get-go what format your data should be in, it’s relatively simple to choose a number format for the entire column before entering your data.

Just select a column and choose a number format from the Number pane in the Home ribbon: However, things can become troublesome when trying to apply number formatting to an existing range of data.

#VALUE is Excel's way of saying, "There's something wrong with the way your formula is typed.