Wipe out zero values in your worksheet in seconds (2000/2002/2003/2004/2007)

by Kara Soos

Application:

Microsoft Excel 2000/2002/2003/2004/2007

Operating Systems:

Microsoft Windows, Macintosh

Sometimes too many zero values clutter your spreadsheet, making it difficult to read and analyze. But when you use the Find And Replace dialog box to replace the zeros in your worksheet with empty strings, Excel eliminates every zero, even the ones that are part of a legitimate number. For instance, “503” becomes “53” and “10,000” becomes “1.”

Solution: On