LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
One command in one cell initiating another command in another cel. Chas52 Excel Worksheet Functions 3 November 7th 09 06:57 PM
Nesting the ROW() command into a Conditional Format Formula ahalford Excel Worksheet Functions 4 November 6th 08 06:00 PM
Format the command for the Currency button Murray[_3_] Excel Discussion (Misc queries) 4 July 30th 08 08:37 PM
Format Cell command will not function Phil Excel Discussion (Misc queries) 1 January 24th 08 03:47 PM
in vba what command is used to determine if a particular cell on a particular sheet changed? some kind of event? how to get the old and new value of the cell? Daniel Excel Worksheet Functions 1 June 23rd 05 07:53 PM


All times are GMT +1. The time now is 07:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"