remove figures from a cell without removing the formulas

S

signature

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

Paul B

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 said:
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?
 
G

Gord Dibben

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

F5>Special>Constants.

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

Edit>Clear>Contents


Gord Dibben MS Excel MVP
 
S

signature

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.
 
G

Gord Dibben

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


Gord
 
Top