Worksheet Functions
in [Functions]
|
Prev: IF AND question
Next: sorting numbers
From: Denrae on 5 May 2010 20:57 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 5 May 2010 21:12 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 5 May 2010 21:13 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 5 May 2010 22:32 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 6 May 2010 00:00
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? >> |