I'm working on a worksheet to calculate pricing, and a few of the cells with formulas don't calculate, but instead just display the entire formula. I noticed that one cell with a formula was working properly, but when I double-clicked to adjust the formula and then "entered," the formula no longer gave me the answer, but listed the formula. I can't figure out how to correct it without "un-doing" it. It is formatted as "general", and still doesn't work. (Some formulas work. cntl+~ didn't help - thanks though!)
This message was edited by dawn on 2002-04-12 14:25
This message was edited by dawn on 2002-04-12 14:35
This message was edited by dawn on 2002-04-12 14:25
This message was edited by dawn on 2002-04-12 14:35