DDE Command to Format Cell
 

DDE requires you to use Excel 4.0 macro commands

the one you are looking for is

FORMAT.NUMBER(format_text)

the following information is from the MACROFUN help file available from
http://support.microsoft.com/default...NoWebContent=1

Macro Sheets Only
Equivalent to choosing the Number tab in the Format Cells dialog box, which
appears when you choose Cells from the Format menu. Formats numbers, dates,
and times in the selected cells, data labels, and axis labels on charts. Use
FORMAT.NUMBER to apply built-in formats or to create and apply custom
formats.

Syntax

FORMAT.NUMBER(format_text)
FORMAT.NUMBER?(format_text)
Format_text is a format string, such as "#, ##0.00", specifying which
format to apply to the selection.


an alternative is to use the xl4 macro command to run a vba macro - see
http://www.pace.edu/nesug/proceeding.../cc/Cc4016.pdf
for more info.

Hope this helps,
Lynn S
"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
 

Lynn,

That is exactly what I was looking for and it befuddles me
as to why Microsoft wouldn't include those files with
Excel.

Thanks,
Ron

-----Original Message-----
DDE requires you to use Excel 4.0 macro commands

the one you are looking for is

FORMAT.NUMBER(format_text)

the following information is from the MACROFUN help file
available from
http://support.microsoft.com/default.aspx?
scid=http://support.microsoft.com:80/support/kb/articles/Q1
28/1/85.ASP&NoWebContent=1

Macro Sheets Only
Equivalent to choosing the Number tab in the Format Cells
dialog box, which
appears when you choose Cells from the Format menu.
Formats numbers, dates,
and times in the selected cells, data labels, and axis
labels on charts. Use
FORMAT.NUMBER to apply built-in formats or to create and
apply custom
formats.

Syntax

FORMAT.NUMBER(format_text)
FORMAT.NUMBER?(format_text)
Format_text is a format string, such as "#, ##0.00",
specifying which
format to apply to the selection.


an alternative is to use the xl4 macro command to run a
vba macro - see
http://www.pace.edu/nesug/proceeding...0/cc/Cc4016.pd
f
for more info.

Hope this helps,
Lynn S
"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


.