remove figures from a cell without removing the formulas
 

i need to remove figures from a cell in a already formated spreadsheet but i
don't want to remove the formulas. can someone refresh me on how to do this?

remove figures from a cell without removing the formulas
 

signature, try, edit, goto, special, constants, ok delete

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"signature" wrote in message
...
i need to remove figures from a cell in a already formated spreadsheet but
i
don't want to remove the formulas. can someone refresh me on how to do
this?

remove figures from a cell without removing the formulas
 

CTRL + a(twice in 2003) to select all.

F5SpecialConstants.

Select the Constants to find....numbers? and OK

EditClearContents


Gord Dibben MS Excel MVP

On Wed, 13 Sep 2006 15:04:02 -0700, signature
wrote:

i need to remove figures from a cell in a already formated spreadsheet but i
don't want to remove the formulas. can someone refresh me on how to do this?

remove figures from a cell without removing the formulas
 

Hi Gord D,
Thanks for this help, this did remove the data w/o removing the formulas but
it did insert a #DIV/0 error in each cell.

"Gord Dibben" wrote:

CTRL + a(twice in 2003) to select all.

F5SpecialConstants.

Select the Constants to find....numbers? and OK

EditClearContents

remove figures from a cell without removing the formulas
 

In that case, you will have to re-write those formulas to trap the error and
produce a result like 0 or blank.


Gord

On Thu, 14 Sep 2006 09:15:02 -0700, signature
wrote:

Hi Gord D,
Thanks for this help, this did remove the data w/o removing the formulas but
it did insert a #DIV/0 error in each cell.

"Gord Dibben" wrote:

CTRL + a(twice in 2003) to select all.

F5SpecialConstants.

Select the Constants to find....numbers? and OK

EditClearContents