G Guest Sep 24, 2005 #1 when I put a numbers in the cell and click inter..I see the formula in the appointed cell but not the number it self ..please help
when I put a numbers in the cell and click inter..I see the formula in the appointed cell but not the number it self ..please help
R Richard Buttrey Sep 24, 2005 #2 when I put a numbers in the cell and click inter..I see the formula in the appointed cell but not the number it self ..please help Click to expand... It sounds like the cell is formatted as text. Use Format Cells (number tab) and choose General. Then Edit and Enter, and you should see the number. HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________
when I put a numbers in the cell and click inter..I see the formula in the appointed cell but not the number it self ..please help Click to expand... It sounds like the cell is formatted as text. Use Format Cells (number tab) and choose General. Then Edit and Enter, and you should see the number. HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________
A Aladin Akyurek Sep 24, 2005 #3 1. Uncheck the Formulas option on the View tab under Tools|Options if it's checked. 2. Format the cell as General, go the Formula Bar, and hit F2.
1. Uncheck the Formulas option on the View tab under Tools|Options if it's checked. 2. Format the cell as General, go the Formula Bar, and hit F2.
B Bob Phillips Sep 24, 2005 #4 Do you mean you see a formula, like =SUM(A1:A10)? If so, go to Tools>Options>View and uncheck the Formulas check box.
Do you mean you see a formula, like =SUM(A1:A10)? If so, go to Tools>Options>View and uncheck the Formulas check box.
