View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default Regarding CTRL ;

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


"su" wrote in message
...
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?