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