Thread: Date
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default 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.