Format all numbers with NumberFormat '0.0' using VBA
Posted on 2011-09-02
On the active worksheet I would like to search for ALL numeric values (even if they have been entered as text) and apply the following format: NumberFormat '0.0', ie. format all numeric values as numbers with one decimal place.
Help is much appreciated. Thank you very much in advance.