2016 excel formula not updating
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.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.If you find yourself in this boat, try this trick: Start with a range of pre-entered data.In this example, we’re using a column that’s entered as text.In order to solve this problem, we will now use the two methods below.Usually when you create a name for a range, you will directly use the cell reference. Otherwise the blank items will also appear in the reference range.
However, the reference range in the name will not update automatically.
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.
You can update the format of a cell, but sometimes it won’t automatically refresh with the new formatting.
This stubbornness usually happens when choosing a custom number format.