Yes, there is an easy way to globally refresh a range of cells that have had a format change. You can use the "Text to Columns" feature in Excel to refresh the cells and apply the new format.

Here are the steps to follow:

1. Select the range of cells that you want to refresh.
2. Go to the "Data" tab in the ribbon and click on "Text to Columns".
3. In the "Convert Text to Columns Wizard" dialog box, select "Delimited" and click "Next".
4. In the next step, make sure that all the delimiters are unchecked and click "Next".
5. In the final step, select the "Text" format and click "Finish".

This will refresh all the cells in the selected range and apply the new format. You can also use this method to refresh cells that have other formats, such as date or currency formats.