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