Cell Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
change the formula to round(J28/I28,2) so that the value extracted will
be 0.23
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Macro for extracting the filtered data only. 1
Runtime error 1004 when trying to insert formula in cells 11
Copy value from changing cells without VBA 1
Extract data from csv file 4
Runtime Error 1004 when runing Sub() from btnClick 2
Extract data from XML file and populate them into cells 1
Averaging without #DIV0! 11

Back
Top