Cell evaluation

[Bob789]

After running a macro with its final step to copy and then past everything as a value, the formula =IF(CELL("TYPE",E2)="B","",+E2) will evaluate to a blank cell when E2 was originally blank but the formula =IF(CELL("TYPE",K2)="B","",(VALUE(LEFT(K2,3)&MID(K2,5,3)&RIGHT(K2,4)))) when K2 was originally blank evaluates to a cell with an apostrophe. Does anyone know how to have this second formula evaluate to a blank cell without the apostrophe.

[mdmackillop]

Can you post a sample file together with the relevant part of your macro

[offthelip]

It evaluates to a blank cell when I tried it. This is correct because yor equation :
=IF(CELL("TYPE",K2)="B","",***xx)
will always evaluate to a blank cell what ever you put for the ***xx bit.