How do I convert cells containing formulas to text (value returned

Is there a way to convert the data returned from a formula to text and remove
the formula? For example, I have a cell containing this formula:
=IF('Current Registrants'!F5="yes", 'Current Registrants'!J5, 0). After the
value has been returned, I would like to convert that cell to the return
value & get rid of the formula. Is this possible? Thank you for your
suggestions.

select the range
copy
edit->paste special->values



"Kim" <Kim@discussions.microsoft.com> wrote in message
news:D6502B36-8B6E-4BEC-9BF4-62C4E73171AF@microsoft.com...
> Is there a way to convert the data returned from a formula to text and
> remove
> the formula? For example, I have a cell containing this formula:
> =IF('Current Registrants'!F5="yes", 'Current Registrants'!J5, 0). After
> the
> value has been returned, I would like to convert that cell to the return
> value & get rid of the formula. Is this possible? Thank you for your
> suggestions.

Copy the formula cell and go to Edit > Paste Special.
Click on "Value" and press OK.

HTH
Jason
Atlanta, Ga

>-----Original Message-----
>Is there a way to convert the data returned from a
formula to text and remove
>the formula? For example, I have a cell containing this
formula:
>=IF('Current Registrants'!F5="yes", 'Current
Registrants'!J5, 0). After the
>value has been returned, I would like to convert that
cell to the return
>value & get rid of the formula. Is this possible?
Thank you for your
>suggestions.
>.
>

THANK YOU!

"N Harkawat" wrote:

> select the range
> copy
> edit->paste special->values
>
>
>
> "Kim" <Kim@discussions.microsoft.com> wrote in message
> news:D6502B36-8B6E-4BEC-9BF4-62C4E73171AF@microsoft.com...
> > Is there a way to convert the data returned from a formula to text and
> > remove
> > the formula? For example, I have a cell containing this formula:
> > =IF('Current Registrants'!F5="yes", 'Current Registrants'!J5, 0). After
> > the
> > value has been returned, I would like to convert that cell to the return
> > value & get rid of the formula. Is this possible? Thank you for your
> > suggestions.
>
>
>

Thanks!

"Jason Morin" wrote:

> Copy the formula cell and go to Edit > Paste Special.
> Click on "Value" and press OK.
>
> HTH
> Jason
> Atlanta, Ga
>
> >-----Original Message-----
> >Is there a way to convert the data returned from a
> formula to text and remove
> >the formula? For example, I have a cell containing this
> formula:
> >=IF('Current Registrants'!F5="yes", 'Current
> Registrants'!J5, 0). After the
> >value has been returned, I would like to convert that
> cell to the return
> >value & get rid of the formula. Is this possible?
> Thank you for your
> >suggestions.
> >.
> >
>