Formula staying as text in cell

R

robbbo

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I have been having an issue with formulas remaining as text. Example: I type in a cell "=A10" and instead of displaying the contents of A10 I get +A10. It especially happens when I write a formula to display a value from a cell in another TAB.

Even when I type an "=" sign and then select the desired cell it come back with the formula not the desired value.
 
C

CyberTaz

That makes it easier :) The first thing to check is Excel> Preferences>
Calculation. Make sure it's set to Automatic. While you're there go to the
View prefs to make sure you don't have 'Show Formulas' checked.

HTH |:>)
Bob Jones
[MVP] Office:Mac
 

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

Conditional formatting by number of characters in cell 2
breaking text into multiple cells 5
Conditional formating based on another cell value 3
Formula referencing other file show formula not result 6
Individual Cell in a Predefined column 0
apple + - (minus key for date - 4/29/10) 2
copy paste errors using automator in excel 1
Subtracting 50 minutes from a formula 4

Top