DDE Command to Format Cell
 

How about [SELECT("R10C5")][Selection.NumberFormat "0.00"]


--

John

johnf202 at hotmail dot com


"Ron Louzon" wrote in message
...
What is the DDE command to format an Excel cell? I want
to format a cell with NumberFormat="0.00". How do I do
this via DDE? I tried

[SELECT("R10C5")][Selection.NumberFormat("0.00")]
[SELECT("R10C5")][Cells.NumberFormat("0.00")]
[SELECT("R10C5")][Select.NumberFormat("0.00")]

but none of this works....obviously.

thanks,
Ron

DDE Command to Format Cell
 

Thanks, but, that didn't work either.
I have been able to change the font in the cell and the
command was

[SELECT("r10C5")][FONT.PROPERTIES(,"Bold")]

I would expect the cell formatting to use a NumberFormat
property of some object but I don't know this.

-----Original Message-----
How about [SELECT("R10C5")]
[Selection.NumberFormat "0.00"]


--

John

johnf202 at hotmail dot com


"Ron Louzon" wrote in
message
...
What is the DDE command to format an Excel cell? I want
to format a cell with NumberFormat="0.00". How do I do
this via DDE? I tried

[SELECT("R10C5")][Selection.NumberFormat("0.00")]
[SELECT("R10C5")][Cells.NumberFormat("0.00")]
[SELECT("R10C5")][Select.NumberFormat("0.00")]

but none of this works....obviously.

thanks,
Ron


.