My workaround for this is:

1. Use the Find tab and Find All (Values). (Tick "Match entire cell contents" if you only want cells with an EXACT value to be replaced. For example 3.53, but not 13.53.)
2. Switch to Replace tab, change "Find what:" text box to "*" (without the quotes).
3. Click the first item in the found items box, scroll to the bottom and Shift-click the bottom item in the found items box.
4. Enter the "Replace with:" value, and click Replace All.