Ask Different is a question and answer site for power users of Apple hardware and software. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a cell with the following content 2262/4121. I want to have a cell next to it that contains the result of that expression. Is there a function for that?

share|improve this question
up vote 3 down vote accepted

You can use the VALUE() function for that. Its only argument is the cell that you want to evaluate.

share|improve this answer
On the spot. Thank you a bunch. – Fork Oct 9 '11 at 14:09
It only works if the source text cell contains a mathematical expression in the form of "a/b". Any other operator such as +-* fails. Also multiple operands such as "a+b+c-d+e-f+g" are not possible. I would like to have my source text cell with i.e. "1+2+3-4+5-6.7+8.99" and another cell evaluating the content of that source cell. – porg Jun 26 '13 at 19:58
Anyone with a solution for evaluating a cell with multiple arbitrary operands? – porg Apr 30 '14 at 15:00

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.