| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date
I used to be able to type "Control + semicolon" to get the current date, this
has stopped working. Please help, Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date
What are you getting when you hit CTRL+ semicolon (;)?
If you are getting a decimal number instead, then check your Transition options. Tools-Options-Transistion (tab)-Sheet Options (section). Uncheck "Transition formula evaluation" and "Transition formula entry". HTH, Paul "charlie" wrote in message ... I used to be able to type "Control + semicolon" to get the current date, this has stopped working. Please help, Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date
Thanks, but no I get nothing, cell remains empty.
"PCLIVE" wrote: What are you getting when you hit CTRL+ semicolon (;)? If you are getting a decimal number instead, then check your Transition options. Tools-Options-Transistion (tab)-Sheet Options (section). Uncheck "Transition formula evaluation" and "Transition formula entry". HTH, Paul "charlie" wrote in message ... I used to be able to type "Control + semicolon" to get the current date, this has stopped working. Please help, Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date
Sounds strange.
How about if you just type a semicolon without using CTRL? Do you get a semicolon as expected? Try typing todays date manually. Does it show? Verify the formula bar to see if anything shows there. Check the text color for the cell...or check conditional formatting for the cell. "charlie" wrote in message ... Thanks, but no I get nothing, cell remains empty. "PCLIVE" wrote: What are you getting when you hit CTRL+ semicolon (;)? If you are getting a decimal number instead, then check your Transition options. Tools-Options-Transistion (tab)-Sheet Options (section). Uncheck "Transition formula evaluation" and "Transition formula entry". HTH, Paul "charlie" wrote in message ... I used to be able to type "Control + semicolon" to get the current date, this has stopped working. Please help, Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
| Make date change in excel to current date when opening daily? | Excel Discussion (Misc queries) | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Hybrid Mode
