View Single Post
  #4   Report Post  
smart.daisy
 
Posts: n/a
Default

You can try =value(D2), and you can round(value(D2),3) if you'd like to get
it rounded.

"PeDevillers" wrote:

Hi,

I made some search before, but too much information at the same time.
So I post this question:

In cell D2 , I have the following content : 10002/(14971213 - 37375)
/1000000)

In cell E2, I would like to have the result value of data in cell D2
: 669,754

I would not work with "left...len... search... right.." as the format
( then formula ) in cell D2 may change.
Is there a function giving the computed result of a cell and put the
result in another one?

Best regards

Pierre