Regarding CTRL ;

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

su - 18 Mar 2008 12:37 GMT

hi
Usually if we type CTRL; in Excel sheet we get date. Now i am facing a
problem and date is not being displayed? can any one help me out to resolve
this issue?

Reply to this Message

Bernie Deitrick - 18 Mar 2008 14:44 GMT

su,

What is being displayed? Are the cells previously formatted as something other than General or Date?
If, for example, you have them formatted or 2 decimal places, you will get the numeric date value
associated with today's date (39525.00).

HTH,
Bernie
MS Excel MVP

> hi
> Usually if we type CTRL; in Excel sheet we get date. Now i am facing a
> problem and date is not being displayed? can any one help me out to resolve
> this issue?

Reply to this Message

Bob I - 18 Mar 2008 14:48 GMT

It would assist in problem resolution if you described what was
displayed or what happened when you press Ctrl+; and if it is only one
sheet, one workbook, or one cell.

> hi
> Usually if we type CTRL; in Excel sheet we get date. Now i am facing a
> problem and date is not being displayed? can any one help me out to resolve
> this issue?

Reply to this Message