| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
On the celd show a formule not its value, why??
I have in the worksheet, one celd that show it a formule (i don't know why)
not its value. Anybody, why it the reason? and how do i to show the value? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
On the celd show a formule not its value, why??
1. clear the cell
2. format the cell as General 3. re-enter the formula -- Gary's Student gsnu200705 "adis" wrote: I have in the worksheet, one celd that show it a formule (i don't know why) not its value. Anybody, why it the reason? and how do i to show the value? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
On the celd show a formule not its value, why??
if it's only one cell then check it isn't formatted as text. Cut the formula
re-format as general and paste it back "adis" wrote: I have in the worksheet, one celd that show it a formule (i don't know why) not its value. Anybody, why it the reason? and how do i to show the value? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
On the celd show a formule not its value, why??
In Tools - Options - View you can tick to show the formula instead of the
answer with the tick box 'formula' I would suggest clicking on your cell and then going in the options and unticking the box. "adis" wrote: I have in the worksheet, one celd that show it a formule (i don't know why) not its value. Anybody, why it the reason? and how do i to show the value? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
On the celd show a formule not its value, why??
Re-format as General then F2ENTER is sufficient.
No need for cutting and pasting. Gord Dibben MS Excel MVP On Fri, 9 Feb 2007 12:12:00 -0800, Mike wrote: if it's only one cell then check it isn't formatted as text. Cut the formula re-format as general and paste it back "adis" wrote: I have in the worksheet, one celd that show it a formule (i don't know why) not its value. Anybody, why it the reason? and how do i to show the value? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show last number entered | Excel Discussion (Misc queries) | |||
| Show data used and percent label | Charts and Charting in Excel | |||
| leading zeros are not showing in the formula bar but do show in ce | Excel Discussion (Misc queries) | |||
| Show values from other sheet | Excel Worksheet Functions | |||
| with formulas that show negative results I want to show zero inste | Excel Discussion (Misc queries) | |||
Linear Mode
