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.

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.

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.




.

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.




.

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.




.



.

Another approach would be to leave that formula alone and use the *1 when
you work with it

in A1 =(RTD("Ticks.RTD","station1","IBM","LAST")
similar in A2, A3

in A4

=A1*1 + A1*2 + A1*3

if you expect them to be numbers

or if you just want to format them, put the formulas in column A, then in B
put in

=if(iserror(A1*1),A1,A1*1)
You could then hide column A perhaps.

Formatting would only be meaningful when a number is returned.

--
Regards,
Tom Ogilvy

Serge wrote in message
...
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.




.



.