Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Chris Bowling
 
Posts: n/a
Default When inserting a simple "Sum" formula all I get is the formula.

I need to see the calculation and not the formula. I've used this process for
years and have never had problems.
  #2   Report Post  
Posted to microsoft.public.excel.charting
davesexcel
 
Posts: n/a
Default When inserting a simple "Sum" formula all I get is the formula.


goto tools=options=view and make sure formulas are not ticked off


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=517335

  #3   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme
 
Posts: n/a
Default When inserting a simple "Sum" formula all I get is the formula.

1) Make sure the cell is not formatted Text; if so, format it General then
open the cell (F2 or double click) then Enter.
2) Make sure you do not have View Formulas on: hold CTRL+` (the key to left
of 1 on top row of so-called typewriter keys)
If nothing works: enter some simple formula { =A1+A2 } somewhere and tell us
what results
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Chris Bowling" <Chris wrote in message
...
I need to see the calculation and not the formula. I've used this process
for
years and have never had problems.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why wont this simple formula work Bigredno8 Excel Discussion (Misc queries) 3 December 7th 05 03:22 AM
Formula Problem - interrupted by #VALUE! in other cells!? Ted Excel Worksheet Functions 17 November 25th 05 05:18 PM
Help with what should be a simple formula B Millar via OfficeKB.com Excel Worksheet Functions 2 June 16th 05 04:18 PM
inserting data from a row to a cell, when the row number is specified by a formula in a cell [email protected] New Users to Excel 2 January 6th 05 07:18 AM
Inserting row but with formula carried down Steve R Excel Worksheet Functions 1 December 15th 04 03:23 PM


All times are GMT +1. The time now is 01:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"