View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] shahidsheikh10@yahoo.com is offline
external usenet poster
 
Posts: 1
Default Convert cell value from a formula to a valve on save

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