You can also delete the values via code if needed:

Sub DeleteNumbers()
On Error Resume Next
Cells.SpecialCells(xlCellTypeConstants, xlNumbers).ClearContents
End Sub

Be careful with this. Since dates are stored as numbers, it will delete
them too.

"Ron de Bruin" wrote:

Hi dranreb

Make a copy of the worksheet
F5Special
Constants
OK
Delete the selection now

--
Regards Ron de Bruin
http://www.rondebruin.nl


"dranreb" wrote in message ...
I wanted to clear the values in a spreadsheet without deleting the formulas
or formatting in the spreadsheet. For example: A budget sheet made for every
year, the formulas and formatting remains the same, only the values change.
I tried paste special formulas....in this case, if values are present, they
get copied too.