Thread: Date
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Charlie Charlie is offline
external usenet poster
 
Posts: 703
Default 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.