Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can i set a static date and time in excel
The help function says to do this: Current date and time Select a cell and
press CTRL+; then SPACE then CTRL+SHIFT+; I do CTRL+ and i get the 'insert' window and can go no further. What am i doing wrong? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can i set a static date and time in excel
You don't type the '+' character. In the documentation, this
means press CTRL and ; or : . "ucastores" wrote in message ... The help function says to do this: Current date and time Select a cell and press CTRL+; then SPACE then CTRL+SHIFT+; I do CTRL+ and i get the 'insert' window and can go no further. What am i doing wrong? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can i set a static date and time in excel
The HELP file is mis-leadng you. When it says:
press CTRL+; it really means press the CNTRL key and the ; key at the same time The + really means at the same time. -- Gary's Student "ucastores" wrote: The help function says to do this: Current date and time Select a cell and press CTRL+; then SPACE then CTRL+SHIFT+; I do CTRL+ and i get the 'insert' window and can go no further. What am i doing wrong? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using VLOOKUP with a Date and Time | Excel Discussion (Misc queries) | |||
How to Join/concatenate a date field with a time field in Excel? | Excel Discussion (Misc queries) | |||
Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
Excel Date Time to Unix Time | Excel Discussion (Misc queries) | |||
Excel: Add time to a date and time column? | Excel Worksheet Functions |