Value does not display in cell

  • Thread starter Thread starter TJ
  • Start date Start date
T

TJ

Does anyone have an idea on this. I'm using one worksheet
for my source material and another for a summary. I put
the formula in the source worksheet and the value appears
in the cell. I then do a copy and special paste into the
correct cell in the summary worksheet. The value is then
pasted in the cell, because one can see it in the formula
line, however the value does not appear in the cell
itself. The value in this case is zero.

Thanks
 
Try this:

Click Tools > Options > View tab

Check "Zero values" > OK

("Zero values" is most probably unchecked)
 
TJ said:
Does anyone have an idea on this. I'm using one worksheet
for my source material and another for a summary. I put
the formula in the source worksheet and the value appears
in the cell. I then do a copy and special paste into the
correct cell in the summary worksheet. The value is then
pasted in the cell, because one can see it in the formula
line, however the value does not appear in the cell
itself. The value in this case is zero.

Thanks

Destination workbook:
Tools > Options > View tab
Do you have "Zero Values" checked?
If not , zero will not show.
 
-----Original Message-----
Does anyone have an idea on this. I'm using one worksheet
for my source material and another for a summary. I put
the formula in the source worksheet and the value appears
in the cell. I then do a copy and special paste into the
correct cell in the summary worksheet. The value is then
pasted in the cell, because one can see it in the formula
line, however the value does not appear in the cell
itself. The value in this case is zero.

Thanks
I check the zero value and what I get are zeros in all
the blank fields of the sheet. Does anyone have another
idea????>
 
Back
Top