Forum Discussion
Bobby Beckstrom
Mar 28, 2018Copper Contributor
NOW()
Can someone help me with the now() function, each time excel updates the time in every cell changes and do not want this. Any help with this would be appreciated.
Jamil
Mar 28, 2018Bronze Contributor
Hi Bobby,
Haytham already provided you a link that shows how you can insert a static date into a cell.
However, if you have many cells that already have NOW() into them and If you want to change them all at once then simply press Ctrl+H and in the find box put =NOW() and in the replace box put the date time for example 28/03/2018 19:03 and click replace All.
Haytham already provided you a link that shows how you can insert a static date into a cell.
However, if you have many cells that already have NOW() into them and If you want to change them all at once then simply press Ctrl+H and in the find box put =NOW() and in the replace box put the date time for example 28/03/2018 19:03 and click replace All.