However if you are in need of this functionality inside your Excel spreadsheet, check out this Find & Replace All macro code that I posted to The Code Vault Blog. I skipped making an Excel version because I feel there are simply too many variables to consider in order to make a macro version for general use. Now I originally made this macro inside PowerPoint but I also went ahead and wrote one for Microsoft Word as well since I could see many people using the functionality inside their documents as well. Therefore, I was left with either doing 10 find and replaces on every file (for digits 0-9) or being a little more creative by writing a VBA macro. Unfortunately I don't think Microsoft's Find/Replace dialog box has that capability (please leave a comment if I'm wrong!). At first I wondered if I could come up with a simple Find/Replace formula that could replace all numbers with an x. Now that I had determined my process, I needed to do a lot of overwriting.
The method I decided on was to get rid of all the figures and add a numerical placeholder (I designated this with the character 'x' for each digit). Because I didn't want the requested data to show our company's non-public results, I needed to somehow classify the numbers.
Recently I found myself in a situation where another company wanted to see the formatting of numerous reports and presentations I was routinely putting together.