You can update it by double-clicking the cell, making no changes, and then press Enter, but this can be very tedious.
This process is particularly troublesome when importing significant amounts of data.
Most of the time, you will search on the Internet for some advice.
However, data recovery is not as easy as you may think.
To speed things up, select the column and go to the Data ribbon and click Text to Columns. For this reason, this trick will not work for cells that are formulas.
If you have formulas, pressing F9 should recalculate the sheet and update the number format.
When you set the cell formatting to “Text”, Excel treats the formula as text and shows it instead of evaluating it. Use Ctrl-Alt-F9 (instead of the normal F9) to force calculations across the worksheet. Find and replace = with = (equal sign with equal sign) - apparently this can solve the problem.There’s a quirk with Microsoft Excel 2010 (and possibly other versions) where custom number formats don’t get applied to existing data.Anna Ma is a data recovery expert in Data Numen, Inc., which is the world leader in data recovery technologies, including repair Word docx data error and outlook repair software products.You type a formula in a cell, then you press ENTER. To fix this error and get back the values (or results) just press CTRL ` again or click on the “Show formulas button” You may have set the cell formatting to “Text” and then typed the formula in it.