View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron Louzon Ron Louzon is offline
external usenet poster
 
Posts: 2
Default 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



.