Values are not visible

[Milan]

I have a worksheet with column "c" showing a result of a formula. I'm just
simply trying to copy this number to another cell/column by using +. Though
the number is visible on column "C" it is not visible on the column that I'm
trying to copy with +.

Please help.

Thanks a million in advance

 

[Max]

Not sure what's happening, but if you want to link to col C,
you could try this in say, E1: =IF(C1="","",C1)
Copy E1 down as far as required

 

[Mike Rogers]

Milan

When you move data, which is the results of a formula, with the drag handle
(plus"+" sign) those references that are not absolute will increment to the
appropriate cells when you drag. If you want to move the data it would be
better to copy then Paste special/values.

Mike Rogers