| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing a cell formula to value before save
when i enter the =now() formula in a cell, i can have it changed to the
absolute value upon saving the file (or upon opening). but i need the formula in the template file in order to display the current date and time every time it opens, but as soon as the template file is saved - or opened - (with the VB script for changing the value) the formula changes to absolute? its a stupid question, I know, but are there any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to edit formula without changing formula of each cell | Excel Worksheet Functions | |||
| Changing cell locations with formula? | Excel Discussion (Misc queries) | |||
| changing cell colors with formula | Excel Worksheet Functions | |||
| formula with changing cell ranges | Excel Worksheet Functions | |||
| A cell reference in a formula changing | Excel Worksheet Functions | |||
![des-sa[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
