From: Denrae on
No matter how I enter a function, it displays as text in the cell and doesn't
perform the calculation. How can I enter a simple formula and have it display
the result?
From: "David Biddulph" groups [at] on
I assume that your cell is formatted as text. Format the cell as General
(or Number) and re-enter the formula.
--
David Biddulph


"Denrae" <Denrae(a)discussions.microsoft.com> wrote in message
news:4CB9D07C-43AE-4C4E-BD2B-912D8B51B000(a)microsoft.com...
> No matter how I enter a function, it displays as text in the cell and
> doesn't
> perform the calculation. How can I enter a simple formula and have it
> display
> the result?


From: Ashish Mathur on
Hi,

Ensure that the cell is not formatted as a text value

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Denrae" <Denrae(a)discussions.microsoft.com> wrote in message
news:4CB9D07C-43AE-4C4E-BD2B-912D8B51B000(a)microsoft.com...
> No matter how I enter a function, it displays as text in the cell and
> doesn't
> perform the calculation. How can I enter a simple formula and have it
> display
> the result?

From: Denrae on
Thanks Ashish and David,

I found I had to delete my formulae, reformat the column as General, and
then re-enter the formula before it worked. Problem solved. Neil

"Ashish Mathur" wrote:

> Hi,
>
> Ensure that the cell is not formatted as a text value
>
> --
> Regards,
>
> Ashish Mathur
> Microsoft Excel MVP
> www.ashishmathur.com
>
> "Denrae" <Denrae(a)discussions.microsoft.com> wrote in message
> news:4CB9D07C-43AE-4C4E-BD2B-912D8B51B000(a)microsoft.com...
> > No matter how I enter a function, it displays as text in the cell and
> > doesn't
> > perform the calculation. How can I enter a simple formula and have it
> > display
> > the result?
>
From: Fred Smith on
And, you don't have to delete the formula first. Just reformat, hit F2 and
enter.

In future, make your life easier by ensuring the cells aren't formatted as
text to begin with.

Regards,
Fred

"Denrae" <Denrae(a)discussions.microsoft.com> wrote in message
news:B87F4D66-8B3C-425A-AD28-91032CD9369C(a)microsoft.com...
> Thanks Ashish and David,
>
> I found I had to delete my formulae, reformat the column as General, and
> then re-enter the formula before it worked. Problem solved. Neil
>
> "Ashish Mathur" wrote:
>
>> Hi,
>>
>> Ensure that the cell is not formatted as a text value
>>
>> --
>> Regards,
>>
>> Ashish Mathur
>> Microsoft Excel MVP
>> www.ashishmathur.com
>>
>> "Denrae" <Denrae(a)discussions.microsoft.com> wrote in message
>> news:4CB9D07C-43AE-4C4E-BD2B-912D8B51B000(a)microsoft.com...
>> > No matter how I enter a function, it displays as text in the cell and
>> > doesn't
>> > perform the calculation. How can I enter a simple formula and have it
>> > display
>> > the result?
>>

 |  Next  |  Last
Pages: 1 2
Prev: IF AND question
Next: sorting numbers