How to convert resluts automatically to values in Excel
 

Hi
Does anybody know how, if possible to set up a formula to convert the result
into a value as soon as it has been calculated.
Cheers,
J

How to convert resluts automatically to values in Excel
 

Do you mean..

=VALUE(<your formula)

If this post helps click Yes
---------------
Jacob Skaria


"Hun" wrote:

Hi
Does anybody know how, if possible to set up a formula to convert the result
into a value as soon as it has been calculated.
Cheers,
J

How to convert resluts automatically to values in Excel
 

If the output is a number and in text - you could use =VALUE( A1)

If the output is a date - you can still use VALUE but you will need to
reformat the cell to date

edvwvw


Hun wrote:
Hi
Does anybody know how, if possible to set up a formula to convert the result
into a value as soon as it has been calculated.
Cheers,
J

--
Message posted via http://www.officekb.com