Function fails to calculate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I enter a text function in excel 2003, correct syntax, but instead of showing
the result the cell continues to show the function. Calculation options don't
affect the result. For example, if cell A2 is "AL TOTAL" and I enter
"=left(A2,2)" in another cell, I should get just "AL". Instead I sometimes
get the function "=left(A2,2)" shwoing indefinitiely. This seems to happen
with large spreadsheets.
 
Ensure the cell format is not text. Change it to General, then click on your
cell, hit F2 (to go into edit mode) and Enter.
 

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

use address function to indicate range in calculation 3
Convert a text field to a date 6
Trying to collapse a table, what Function should I use? 3
Negative time displaying as ##### 7
ISNUMBER function problem 1
calculations not working 4
Calculations 1
Calculating Problem: Desperate :( 4

Back
Top