I've set up a macro to enter the NOW function to have the date and time. I want this so it shows down to the seconds. The steps are here:
Go to an empty cell<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
Click Tools, Macro, Record New Macro . . .<o
></o
>
Give a proper name such as Insert_Date<o
></o
>
Hold Shift and type a “D” into the Shortcut Key box<o
></o
>
Select Store In Personal Macro Workbook (unless they always use the same workbook then you can save it to that file, then whomever uses the file can use the macro)<o
></o
>
Click OK<o
></o
>
Type “=now()”<o
></o
>
Click the green checkmark next to the formula bar<o
></o
>
Copy and paste special values<o
></o
>
Click the Stop button on the macro toolbar
The problem is it keeps changing the previous entries to the last date/time entered using the macro. Any suggestions? Using CTRL SHIFT : doesn't give me down to the seconds like I need.
Thanks,
Tom
Go to an empty cell<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
Click Tools, Macro, Record New Macro . . .<o
Give a proper name such as Insert_Date<o
Hold Shift and type a “D” into the Shortcut Key box<o
Select Store In Personal Macro Workbook (unless they always use the same workbook then you can save it to that file, then whomever uses the file can use the macro)<o
Click OK<o
Type “=now()”<o
Click the green checkmark next to the formula bar<o
Copy and paste special values<o
Click the Stop button on the macro toolbar
The problem is it keeps changing the previous entries to the last date/time entered using the macro. Any suggestions? Using CTRL SHIFT : doesn't give me down to the seconds like I need.
Thanks,
Tom