Seems to me on the reference sheet you could trap for 0 and leave the cell
looking blank and no need for a dot at all.

=IF(Sheet2!A1="","",Sheet2!A1)


Gord Dibben MS Excel MVP

On Mon, 18 Dec 2006 08:01:51 -0500, nospam
wrote:

Hi,

This might be an oddball question, but here goes. I have a spreadsheet
that I have to copy data from one sheet to another. Then any blank cells
I have to manually put a period (.) in so that when those cells are
referenced they don't show a 0 on a form we print. Is there any way when
I copy data from one sheet to another I can have excel put the period in
the blank cells automatically?

Here's the scenario: we have to enter certain data copied from our
website. So, we copy it from the site to a sheet in excel. Then we copy
certain columns from that over to another sheet. The data from sheet 2
is then referenced by another sheet which is formatted to be printed on
a company form. It contains some pre-filled info which is printed out
then filled out manually by us. Thus, I need a dot (which doesn't show
up too much on the blank lines, instead of a 0 (which would print on the
blank lines on our form if not for the period(.))

Thanks!