I assume the original expense report workbook is a Template and users are
creating a new workbook based on that Template.

Is that correct?

If so, I can't think of a way to convert from formula to value without manual
intervention on the part of the user before save or VBA intervention with no
user input.


Gord Dibben MS Excel MVP

On Sat, 1 Mar 2008 16:51:04 -0800 (PST), wrote:

Hi all,

I have an expense report spreadsheet which uses the now() function in
one of its cells. I want to convert that cell from a formula to the
valve it equates to when a user saves the spreadsheet for the first
time.

Can this be done without the use of macros?

Thanks,

Shahid