Thank you very much
It's a really help a lot.
Tina
"Peo Sjoblom" wrote:
Nothing wrong, that is the way excel works, you need either VBA or and old
xlm trick which is not recommended since it can crash in earlier versions
here's the VBA version
Option Explicit
Function Eval(myStr As String) As Variant
Eval = Application.Evaluate(myStr)
End Function
=EVAL(A1)
will return 8
http://www.mvps.org/dmcritchie/excel/install.htm
how to install macros or UDFs
--
Regards,
Peo Sjoblom
Portland, Oregon
"tina" wrote in message
...
May I know what is wrong over here?
I have a formula in A1 cell (eq. 3+5 formatted as text) and try to let B1
have the result of A1. so I set B1 =Value(A1)...it doesn't work but it
will
work if I put =value(3+5)...
Is there anyone can tell me what is wrong here?