It doesnot fill 0's, it fills 1, 2, 3 or 4... PS. my data contain only these
numbers. I also want to know whether this has any relevance.
This happens even if I selcted the 1st cell in a different column!!!

"Kazuki" wrote:

How do I replace empty cells in a range of data with the special character - ?
I tried using the following method:
Selecting the range of data, Edit Goto Special Blanks Point to a
cell in the adjacent column with ' - '...
When I selected the first cell in the adjacent column, the blanks in the
selected range is replaced with ' - ' as desired. but if any other cell in
teh adjacent column is selected, the some blanks in the selected range are
filled with 0's.
What is the reason for this?