Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
One command in one cell initiating another command in another cel. | Excel Worksheet Functions | |||
Nesting the ROW() command into a Conditional Format Formula | Excel Worksheet Functions | |||
Format the command for the Currency button | Excel Discussion (Misc queries) | |||
Format Cell command will not function | Excel Discussion (Misc queries) | |||
DDE Command to Format Cell | Excel Programming |