Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I would like to have an icon to select that will insert the current date and
time. I attempted to make a macro to accomplish this and it worked great UNTIL I figured out that every time I entered a new date, it changed them ALL. I need for the date and time to be possibly different. When I use Ctrl + ; I get the date then space once and use Ctrl + Shift + ; and you get the time. This works great however I dont want to do this every time I need this data. PLEASE HELP! :( Signed Frustrated in SC.... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Any quick key to insert current Date and Time? | Excel Discussion (Misc queries) | |||
how do I insert the current time (static) and date in a cell? | Excel Discussion (Misc queries) | |||
Can I automatically enter the current date or current time into a | New Users to Excel | |||
How to insert a current date | Excel Discussion (Misc queries) | |||
how do i insert the current time into a cell, and show different . | Excel Discussion (Misc queries) |