Find and Replace with wildcards 1

="0" & A1 [or the cell that contains your data]

Don't use find and replace. Use string manipulation functions in VBA instead.

You could create a custom format to avoid having to create a new column on your sheet.

Select all cells you want to change, select format >> cells >> custom and enter 0#;0#;;"0"@

Thanks everyone for their responses. To make life simple I took Melone's '="0" & A1' and then did a copy / paste as value back over the old values. Done deal.

Thanks again, Mark

OK, I am posting this suggestion after you already found a workable solution, but I am going to post my standard answer to so many of these requests:

Install a free copy of ASAP Utilities from
This brilliant free Excel plug-in has dozens (hundreds?) of useful add-in tools, including "ASAP Utilities | Text | Insert before current value". Simply select the block you are interested in, find the appropriate ASAP Utility, enter the character(s) you want to insert, and click on OK. Done!

Hope this helps!