Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Regarding CTRL ;
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Regarding CTRL ;
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. su wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Anyone having Ctrl+C / Ctrl+V problems in E2007? | Excel Discussion (Misc queries) | |||
Ctrl F | Excel Worksheet Functions | |||
How to forbid ctrl+c and ctrl+X in sheet? | Setting up and Configuration of Excel | |||
CARET or ^, as in CTRL but CTRL !!! ??? | Excel Worksheet Functions | |||
CTRL-END | Excel Discussion (Misc queries) |