Brian,

You can manually convert the formula to a fixed date entry by pressing F2
then F9 then Enter.

The VBA equivalent is

Range("A1").Value = Range("A1").Text

You could set up a macro to do the SaveAs after it has fixed the date.
--
John Green
Sydney
Australia


"B. E. Smith" wrote in message
...
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