Cell Data
 

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/I2
Displayed=23

What is extracted = 0.232786543998

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

Cell Data
 

You can do =round(J28/I28,2)*100&"%"

Theo Fanelli wrote:
Thank you for your reply.
What I would like to extract is 23% is that possible?