Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default When I enter a formula, Excel shows the formula not the results

It's as if the cell were formatted for text, but it is formatted for numbers
(or date). When I go through the formula function (rather than straight
entering), I can see in the formula function dialogue box the desired result
- just can't get it in the cell!
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: When I enter a formula, Excel shows the formula not the results

It sounds like your Excel might be set to show formulas instead of the results. This can happen accidentally if you hit a certain keyboard shortcut or if someone else was using your computer and changed the settings. Here's how to fix it:
  1. Select the cell(s) that are showing the formula instead of the result.
  2. Look at the formula bar at the top of the Excel window. If you see the formula in the bar instead of the result, that's the problem.
  3. To fix it, press the
    Formula:
    "Ctrl" 
    and
    Formula:
    "`" 
    keys at the same time. This will toggle between showing formulas and showing results.
  4. If that doesn't work, go to the Formulas tab in the ribbon at the top of the Excel window.
  5. Look for the Formula Auditing section and click on Show Formulas. This will toggle the display of formulas on and off.
  6. If none of these steps work, it's possible that the cell is formatted incorrectly. Right-click on the cell and select Format Cells. Make sure the cell is formatted for the correct type of data (number, date, etc.).
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default When I enter a formula, Excel shows the formula not the results

Does the sheet show the correct result when you press F9? If so, your
file is set for manual calculation. Go to Tools | Options |
Calculation (tab) and check Automatic. Save your file so that it will
be automatic when you next open it.

If not then the cell is probably pre-formatted to text. Changing the
format only comes into effect after the cell has been edited, so
double-click on that cell and then press <Enter.

Hope this helps.

Pete

On Jul 25, 9:02 pm, Pat Adams
wrote:
It's as if the cell were formatted for text, but it is formatted for numbers
(or date). When I go through the formula function (rather than straight
entering), I can see in the formula function dialogue box the desired result
- just can't get it in the cell!



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default When I enter a formula, Excel shows the formula not the result

Neither worked - sorry. When I tried to re-create the problem, I seem to
have this problem only when working with templates created by others outside
of our company. I was wondering if this is peculiar to versionary
differences in Excel (we have Excel 2003) OR if there are security issues
embedded in these templates that prevents formulas from being entered/used.


"Pete_UK" wrote:

Does the sheet show the correct result when you press F9? If so, your
file is set for manual calculation. Go to Tools | Options |
Calculation (tab) and check Automatic. Save your file so that it will
be automatic when you next open it.

If not then the cell is probably pre-formatted to text. Changing the
format only comes into effect after the cell has been edited, so
double-click on that cell and then press <Enter.

Hope this helps.

Pete

On Jul 25, 9:02 pm, Pat Adams
wrote:
It's as if the cell were formatted for text, but it is formatted for numbers
(or date). When I go through the formula function (rather than straight
entering), I can see in the formula function dialogue box the desired result
- just can't get it in the cell!




  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,268
Default When I enter a formula, Excel shows the formula not the result

Replace = with =

to force calculation, make sure the format is not text, then do editreplace
and replace equal sign with equal sign


--
Regards,

Peo Sjoblom



"Pat Adams" wrote in message
...
Neither worked - sorry. When I tried to re-create the problem, I seem to
have this problem only when working with templates created by others
outside
of our company. I was wondering if this is peculiar to versionary
differences in Excel (we have Excel 2003) OR if there are security issues
embedded in these templates that prevents formulas from being
entered/used.


"Pete_UK" wrote:

Does the sheet show the correct result when you press F9? If so, your
file is set for manual calculation. Go to Tools | Options |
Calculation (tab) and check Automatic. Save your file so that it will
be automatic when you next open it.

If not then the cell is probably pre-formatted to text. Changing the
format only comes into effect after the cell has been edited, so
double-click on that cell and then press <Enter.

Hope this helps.

Pete

On Jul 25, 9:02 pm, Pat Adams
wrote:
It's as if the cell were formatted for text, but it is formatted for
numbers
(or date). When I go through the formula function (rather than
straight
entering), I can see in the formula function dialogue box the desired
result
- just can't get it in the cell!








  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,979
Default When I enter a formula, Excel shows the formula not the result

There's a setting to make formulas visible. To turn it off, press the
Ctrl key, and the ` key (accent grave), which may be above the Tab key.

Or, choose ToolsOptions, and on the View tab, remove the check mark
from Formulas.

Pat Adams wrote:
Neither worked - sorry. When I tried to re-create the problem, I seem to
have this problem only when working with templates created by others outside
of our company. I was wondering if this is peculiar to versionary
differences in Excel (we have Excel 2003) OR if there are security issues
embedded in these templates that prevents formulas from being entered/used.


"Pete_UK" wrote:


Does the sheet show the correct result when you press F9? If so, your
file is set for manual calculation. Go to Tools | Options |
Calculation (tab) and check Automatic. Save your file so that it will
be automatic when you next open it.

If not then the cell is probably pre-formatted to text. Changing the
format only comes into effect after the cell has been edited, so
double-click on that cell and then press <Enter.

Hope this helps.

Pete

On Jul 25, 9:02 pm, Pat Adams
wrote:

It's as if the cell were formatted for text, but it is formatted for numbers
(or date). When I go through the formula function (rather than straight
entering), I can see in the formula function dialogue box the desired result
- just can't get it in the cell!






--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

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
Formula shows not results David Excel Worksheet Functions 4 May 25th 07 11:32 PM
can you wrap formula results via a formula eg. Alt Enter Bryan McHugh Excel Discussion (Misc queries) 5 March 8th 07 01:52 AM
Excel Formula Doesn't Execute (Shows formula-not the calcuation) Keys1970 Excel Discussion (Misc queries) 4 November 15th 06 03:12 PM
How do I view formula results intead of formula in excel? davidinatlanta Excel Worksheet Functions 4 February 7th 06 04:02 PM
Cell doesn't show formula result - it shows formula (CTRL + ' doe. o0o0o0o Excel Worksheet Functions 6 November 19th 04 04:13 PM


All times are GMT +1. The time now is 11:09 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"