Forum Discussion
insert date when giving "OK" command
Hello everyone, How do I mark the date that I give "OK" in a cell to appear a specific text (in another cell) along with the date that was given that "OK"? For example. "paid on 10-10-2023"
Select column E, then click the arrow in the lower right corner of the Number group on the Home tab of the ribbon.
Select Custom in the Category list, then type
"Paid on"dd-mm-yyyy
in the Type box.
Click OK.
See the attached demo workbook. You'll have to allow macros when you open it.
