Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Values
When I create an equation in a column...how can I get excel to only show the
number in the cell when I click on it rather than have it show the equation used to obtain this value? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Values
Perhaps the cells are preformatted as TEXT, or your formulas might not have
the equal sign preceeding them. Vaya con Dios, Chuck, CABGx3 "Brad" wrote: When I create an equation in a column...how can I get excel to only show the number in the cell when I click on it rather than have it show the equation used to obtain this value? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Values
On Apr 23, 12:56 pm, Brad wrote:
When I create an equation in a column...how can I get excel to only show the number in the cell when I click on it rather than have it show the equation used to obtain this value? Do you mean in the Formula Bar? Or right in the cell? The formula should show in the Formula Bar, the value should show in the cell. Unless you double click on the cell, which means you are editing it and the formula should then show in the cell. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Values
Hi,
You can use Excel's protection feature to hide the formulas. -- Regards, Ashish Mathur www.ashishmathur.com http://www.linkedin.com/in/excelenthusiasts "Brad" wrote in message ... When I create an equation in a column...how can I get excel to only show the number in the cell when I click on it rather than have it show the equation used to obtain this value? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to assign values to a cell based on values in another cell? | Excel Worksheet Functions | |||
Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets | Excel Discussion (Misc queries) | |||
Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets | Excel Worksheet Functions | |||
Replacing Linked Cell Values w/ Current Values | Excel Worksheet Functions | |||
vlookup, multiple values, sum values into one cell?? | Excel Worksheet Functions |