Prev: IF AND question
Next: sorting numbers
From: Gord Dibben on 6 May 2010 19:44
And if you have enterd many formulas do an edit/replace after re-formatting
to General.

Edit>Replace

What: =

With: =

Replace all

This saves all those F2>Enters


Gord Dibben MS Excel MVP

On Wed, 5 May 2010 22:00:39 -0600, "Fred Smith" <fsmith11(a)yahooo.com> wrote:

>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?
>>>

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