Thread: Cell Data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
yogendra joshi yogendra joshi is offline
external usenet poster
 
Posts: 48
Default Cell Data

change the formula to round(J28/I28,2) so that the value extracted will
be 0.23


Theo Fanelli wrote:

I am extrcting data via DDE from excel to another program.
Is there a way to keep the formating og the number when the data is extracted?
example: cell formula=J28/I28
Displayed=23%

What is extracted = 0.2327865439983