Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula viewing format
I know this is an easy one, I just can't find where to change it:
I working on a worksheet created by someone else and whenever I create a formula in a cell the actual formula shows and not the result, where do I change this? thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula viewing format
The cells you are entering the formulas into sound as if they are formatted
as text, change the format to 'General' Regards, Alan. "Roger" wrote in message ... I know this is an easy one, I just can't find where to change it: I working on a worksheet created by someone else and whenever I create a formula in a cell the actual formula shows and not the result, where do I change this? thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula viewing format
TOOLS
OPTIONS VIEW Tab Uncheck "Formulas" HTH, Elkar "Roger" wrote: I know this is an easy one, I just can't find where to change it: I working on a worksheet created by someone else and whenever I create a formula in a cell the actual formula shows and not the result, where do I change this? thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula viewing format
Roger
Could be either or both of two reasons. 1 The cell is formatted as text. Format as General then F2 and <ENTER 2. You are in "Formula View". Hit CTRL + ` (backquote above Tab key) to toggle on/off. Gord Dibben MS Excel MVP On Fri, 5 Jan 2007 12:40:01 -0800, Roger wrote: I know this is an easy one, I just can't find where to change it: I working on a worksheet created by someone else and whenever I create a formula in a cell the actual formula shows and not the result, where do I change this? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Date format changes to formula | Excel Discussion (Misc queries) | |||
Weird format to formula transition excel 2003 | Excel Worksheet Functions | |||
Format Issue | Excel Worksheet Functions | |||
keeping cell format with formula | Excel Worksheet Functions |