If they're all 3 or 4 digit numbers, you could try a custom number format of:

[999]"x,xxx";[0]"xxx";General





" wrote:

On Mar 10, 4:33 pm, JLatham <HelpFrom @ Jlathamsite.com.(removethis)
wrote:
Perhaps this will give you a head start in writing your macro.

Thanks for the head start.

By the way: I wouldn't consider just coming up with some format to hide the
values - a simple selection of all the cells and Edit | Clear | Formats would
instantly reveal the original values.

Wouldn't be a problem. As I mentioned initially, I am only going to
print what I intend to show. I am not giving anyone the file.

--

Dave Peterson