Here's a simple(ish) script that will look at your selection in Numbers and clear out only cells with number values. It will leave formulas and text alone. Apparently Excel users have this, but there's no easy way to do it in Numbers. If you take this script and put it in a Shortcut, it can be just as easy to do in Numbers though. I'll attach the Shortcut to this post.
Note: This is Club MacMost exclusive content. To view this video click the thumbnail below to go to the post as Patreon.com. Once there you will be able to view the video as long as you are logged into your Patreon account and a current supporter of MacMost at the "Club MacMost" or higher level.