Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 430
Default Hide Formula and Show Value

'Tools'.....'options' ...... 'window options' ... uncheck the box next to
'formulas'

"Truantjlj50" wrote:

When I create a formula, I am seeing the formula in the cell rather than the
value.

Excel Help says to use CTRL + `. I have tried that, and it does not work.

Help.

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 to show a formula in a different cell Todd Excel Worksheet Functions 1 August 30th 06 10:31 PM
How do I hide a formula so it will not show on the spreadsheet? Brenda Excel Worksheet Functions 1 April 5th 06 02:14 PM
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 08:02 PM
Show Formula / Hide Formula DejaVu Excel Discussion (Misc queries) 5 August 31st 05 03:42 PM
Cell doesn't show formula result - it shows formula (CTRL + ' doe. o0o0o0o Excel Worksheet Functions 6 November 19th 04 03:13 PM


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