Convert cell value from a formula to a valve on save

[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

 

[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

 

[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