Convert cell value from a formula to a valve on save

S

shahidsheikh10

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
 
P

Pete_UK

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
 
G

Gord Dibben

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
 
Top