TYPINATOR INSERT TIME UPDATE
Is there some derivative of this formula that will not auto update the date and time? Q: By default it will auto update it would be such an easy solution if there was a formula for current date and time that would NOT auto update. And if it is frequently used a smart tip is to leave the "=Now" in a dedicated cell so it is always available to be copied and then pasted (value only). Then to get the value from it without auto update, copy (cmd C) and then paste the value without the formatting (cmd shift V). Here are the workarounds I have found with my questions:
I need to input the date and time often hundreds of times daily so a quick keystroke would be gold for me. The workarounds I have found can get the job done but are either confusing to set up or they require so many keystrokes that it's inefficient. It seems there is yet to be a simple method to input date & time in a single cell that is static (will not auto update when the file is opened later). I just read a pile of threads on this topic going back to 2014, as well as in non-Apple forums.
0 kommentar(er)
