RTD cannot return an empty value
 

I've built a RTD component in VB6 and it works fine when returning values
(numbers, string) however in certain circumstances I want to return an Emtpy
cell value.

Setting the return value to Empty just like you would in excel VBA returns
to the client as 0 which is not correct. Has anybody found a workaround for
this issue or is this a known bug within MS?

Thanks,