You're right, I'll use your suggestion. It's just not all
tickers return back price and multiplying empty by 1
returns ugly #VALUE, but I guess I can handle it
differently.


-----Original Message-----
If you wanted it to be a number, I would use:

=(RTD("Ticks.RTD","station1","IBM","LAST")*1)

Not sure why you don't want to.


The lastest kick is
=--(RTD("Ticks.RTD","station1","IBM","LAST")

Maybe you will like that more.

--
Regards,
Tom Ogilvy


"Serge" wrote in message
...
I see, thanks Tom. I modified RTD server code from
microsoft.
=RTD("Ticks.RTD","station1","IBM","LAST")

I noticed RTD method IRtdServer_RefreshData(TopicCount
as
long) as Variant() returns variant type. Is variant type
causing client to display queries as text?
But then I tried using microsoft RTDTime example, I
could
format that cell fine.

I would prefer not to use:
=(RTD("Ticks.RTD","station1","IBM","LAST")*1)

The way I populate cells is thru macro:
range("B" & i).formula = "=RTD..."
i=i+1





-----Original Message-----
The cells contains text instead of numbers. You can't
format text (even if
it looks like a number).

What is the RTD function.

--
Regards,
Tom Ogilvy

"Serge" wrote in message
...
Neight fom GUI nor VBA.

searched google groups found semi-solution:
<<
Type the number 1 in any empty cell (make sure that
the
NumberFormat of the
cell with the number 1 is General or Number)
Copy it
Select all problematic date cells
Paste Special = Operation | Multiply


It worked. Question is why and how to fix it.
The cell formula contains RTD function.

Thank you.




.



.