Is there a way to use the (TODAY) function so that is saves in a saved as
worksheet as text.

Here's what I'm after. I have a protected sheet that I do deal calculations
on, that I save as "the deal" once I reach an agreement with my customer.

Is there a way for the date to save on the "saved as" file as text so that
the date doesn't change from that point forward?

In other, After I save the file as the customers final deal. How do I make
the date remain the same hence forward automatically?

Thanks to anyone that can help.

Brian