J
jayindy
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Hi experts,
Simple question, can we customize the apple plus minus key that yields a date (format is "4/29/10" so it will appear in the format below, or anything that might include the time?
"Thu Apr-29-10 9:45:44 AM"
Or is there also a apple + ? key that gives the time? This would allow me to apple-, space bar, apple? to get a date & time stamp into a cell quickly.
advance thanks, jay
For them moment I have this formula below, but I have to do a paste special to get just the value in the cell...
=" "&CHOOSE(WEEKDAY(NOW()),"Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun"&" "&TEXT(TODAY(),"mmm-d-yy"&" "&TEXT(NOW(),"h:mm:ss AM/PM"
Simple question, can we customize the apple plus minus key that yields a date (format is "4/29/10" so it will appear in the format below, or anything that might include the time?
"Thu Apr-29-10 9:45:44 AM"
Or is there also a apple + ? key that gives the time? This would allow me to apple-, space bar, apple? to get a date & time stamp into a cell quickly.
advance thanks, jay
For them moment I have this formula below, but I have to do a paste special to get just the value in the cell...
=" "&CHOOSE(WEEKDAY(NOW()),"Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun"&" "&TEXT(TODAY(),"mmm-d-yy"&" "&TEXT(NOW(),"h:mm:ss AM/PM"