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

The cell has been formatted as Text:

1. clear the cell
2. format the cell as General
3. re-enter the formula
--
Gary''s Student


"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
Hide Formula and Show Value tim m Excel Discussion (Misc queries) 0 November 29th 06 05:41 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 03:31 PM.

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"