Hi Ron:

Thanks a ton. This worked. I tried Option 1. I donot know though why
typing apostrophe and then holding down ctrl and enter does.

Thanks a lot.


"Ron Coderre" wrote:

I can think of two other options you might use:

1)Massage your source data.
-EditGoToSpecial Cells: blanks, click [OK]
-Type an apostrophe then hold down [Ctrl]+[Enter]

OR

2)Add a column of formulas to your source data that will display labels (if
they exist) or empty text ("") if they don't and use that column instead of
the data column
Example: =if(isblank(B1),"",B1)

Does that help?

--
Regards,
Ron