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

If you want it to happen automatically you will need a macro.

However, you could tell your user to use <copy Edit | Paste Special |
Values (check) | OK then <Esc on the cell the first time he/she uses the
file.

Or you could tell the user to do CTRL-semicolon (for the date) then <space
then CTRL-SHIFT-semicolon (for the time) then <Enter on the cell.

Which do you think is likely to happen correctly every time?

Hope this helps.

Pete

wrote in message
...
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

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