|
|
Formula showing in cell
When I type a formula in a cell after hitting enter, the forumla not the
value appears in the cell. It is not toggled to show the formula nor are the
existing formulas in other cells showing.
Any ideas?
Carolyn
|
|
0
|
|
|
|
Reply
|
 Utf
|
4/1/2010 6:53:06 PM |
|
I had copied cells from another workbook. When I inserted a column it must
have brought in something that made the formula text. When I copied and did
an paste special into the column, the formulas started entering correctly.
Carolyn
"Carolyn" wrote:
> When I type a formula in a cell after hitting enter, the forumla not the
> value appears in the cell. It is not toggled to show the formula nor are the
> existing formulas in other cells showing.
>
> Any ideas?
>
> Carolyn
|
|
|
0
|
|
|
|
Reply
|
Utf
|
4/1/2010 6:59:01 PM
|
|
Cell format is most likely Text.
Re-format the cell to General then F2 and ENTER to re-enter the formula.
Gord Dibben MS Excel MVP
On Thu, 1 Apr 2010 11:53:06 -0700, Carolyn
<Carolyn@discussions.microsoft.com> wrote:
>When I type a formula in a cell after hitting enter, the forumla not the
>value appears in the cell. It is not toggled to show the formula nor are the
>existing formulas in other cells showing.
>
>Any ideas?
>
>Carolyn
|
|
|
0
|
|
|
|
Reply
|
Gord
|
4/1/2010 7:12:51 PM
|
|
Too late.
Always best to keep in the same thread rather than posting a new one.
Gord Dibben MS Excel MVP
On Thu, 1 Apr 2010 11:59:01 -0700, Carolyn
<Carolyn@discussions.microsoft.com> wrote:
>I had copied cells from another workbook. When I inserted a column it must
>have brought in something that made the formula text. When I copied and did
>an paste special into the column, the formulas started entering correctly.
>
>Carolyn
>
>"Carolyn" wrote:
>
>> When I type a formula in a cell after hitting enter, the forumla not the
>> value appears in the cell. It is not toggled to show the formula nor are the
>> existing formulas in other cells showing.
>>
>> Any ideas?
>>
>> Carolyn
|
|
|
0
|
|
|
|
Reply
|
Gord
|
4/1/2010 7:14:36 PM
|
|
Format the cell to something other than text, re-enter the formula.
--
Best Regards,
Luke M
"Carolyn" <Carolyn@discussions.microsoft.com> wrote in message
news:33CF371C-3F96-4026-AEEE-E48D21B7B052@microsoft.com...
> When I type a formula in a cell after hitting enter, the forumla not the
> value appears in the cell. It is not toggled to show the formula nor are
> the
> existing formulas in other cells showing.
>
> Any ideas?
>
> Carolyn
|
|
|
0
|
|
|
|
Reply
|
Luke
|
4/1/2010 7:57:44 PM
|
|
|
4 Replies
302 Views
(page loaded in 0.048 seconds)
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
79177 articles. 
66 followers. 