D Dylan @ UAFC Jan 20, 2009 #1 I have one column in work sheet were the formula shows in the cell and will not go away waht can i do
I have one column in work sheet were the formula shows in the cell and will not go away waht can i do
M Mike H Jan 20, 2009 #2 Hi, If it's a single column then it's a fair bet the cell was formatted as text before the formula was entered. Re-format as 'general' with the cell selected tap F2 and enter. Mike
Hi, If it's a single column then it's a fair bet the cell was formatted as text before the formula was entered. Re-format as 'general' with the cell selected tap F2 and enter. Mike
G Gord Dibben Jan 20, 2009 #3 If other columns' formulas are OK then I would suggest you have pre-formatted the offending column as text. Format to General then F2 and ENTER on each cell. Gord Dibben MS Excel MVP
If other columns' formulas are OK then I would suggest you have pre-formatted the offending column as text. Format to General then F2 and ENTER on each cell. Gord Dibben MS Excel MVP
