Delete numbers without deleting formula

V

Vince

I did a search and can not find an answer to my problem, I need to Delete numbers without deleting formula...and yes, if you could please use basic terms I am not comp savvy

Thanks for you help.
 
N

Niek Otten

EDit>Go To>Special, Check Constants (and possibly Numbers)
Pess Delete

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel


Vince said:
I did a search and can not find an answer to my problem, I need to Delete
Click to expand...
numbers without deleting formula...and yes, if you could please use basic
terms I am not comp savvy.
 
P

Paul

Vince said:
I did a search and can not find an answer to my problem, I need to Delete
Click to expand...
numbers without deleting formula...and yes, if you could please use basic
terms I am not comp savvy.
Thanks for you help.
Click to expand...

You can use
Edit > Go To > Special > Constants > OK
to select all cells containing constants rather than formulas, which you can
then clear all together by pressing the Delete key on the keyboard.

You may have (for example) text as well as numbers. Both of these are
considered as constants. If you only want to delete the numbers, use
Edit > Go To > Special > Constants
but remove the tick against "Text" before pressing OK.

If you want to do this to only a part of your worksheet, select that part
before starting the process.
 
A

Andrew

Just a thought but how about using the special paste function in the
Edit Menu or Right Click Menu?

I was thinking that you could a) open up a new sheet, then b) copy and
paste Formulas (and then paste Format also if you wanted too).

One possible problem is how your formulas are set up. It might be the
case that the formulas by themselves might show an error message
without any data to reference.
 
Top