Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Peculiar Date problem
One column is filled with dates but in each cell one can see the dates in
number format (though the formatting has been selected as date type) and at the same time each cell will give the date near the space provided adjacent to the formula bar but in the cell it will display the number. Please suggest what could be the problem?? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Peculiar Date problem
One possibility, try hitting CTRL+`
The ` character can be found to the left of the 1 key. Mike "Shweta Srivastava77" wrote: One column is filled with dates but in each cell one can see the dates in number format (though the formatting has been selected as date type) and at the same time each cell will give the date near the space provided adjacent to the formula bar but in the cell it will display the number. Please suggest what could be the problem?? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Peculiar Date problem
That's amazing!!.. It sorted everything at one click.. Please tell me the
reason for it?? How it worked and what was the mistake while typing was done. Shweta "Mike H" wrote: One possibility, try hitting CTRL+` The ` character can be found to the left of the 1 key. Mike "Shweta Srivastava77" wrote: One column is filled with dates but in each cell one can see the dates in number format (though the formatting has been selected as date type) and at the same time each cell will give the date near the space provided adjacent to the formula bar but in the cell it will display the number. Please suggest what could be the problem?? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Peculiar Date problem
It's a bit of Excel funtcionality that allows you to view formulas instead of
the results of those formulas. Can be quite useful. Most people who get caught out by this have activated it by mistake. Mike "Shweta Srivastava77" wrote: That's amazing!!.. It sorted everything at one click.. Please tell me the reason for it?? How it worked and what was the mistake while typing was done. Shweta "Mike H" wrote: One possibility, try hitting CTRL+` The ` character can be found to the left of the 1 key. Mike "Shweta Srivastava77" wrote: One column is filled with dates but in each cell one can see the dates in number format (though the formatting has been selected as date type) and at the same time each cell will give the date near the space provided adjacent to the formula bar but in the cell it will display the number. Please suggest what could be the problem?? |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Peculiar Date problem
Just to add...
It's the short cut key for: Tools|Options|View tab|Formulas Shweta Srivastava77 wrote: That's amazing!!.. It sorted everything at one click.. Please tell me the reason for it?? How it worked and what was the mistake while typing was done. Shweta "Mike H" wrote: One possibility, try hitting CTRL+` The ` character can be found to the left of the 1 key. Mike "Shweta Srivastava77" wrote: One column is filled with dates but in each cell one can see the dates in number format (though the formatting has been selected as date type) and at the same time each cell will give the date near the space provided adjacent to the formula bar but in the cell it will display the number. Please suggest what could be the problem?? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Formula Problem - Leave date blank if Null | Excel Worksheet Functions | |||
Peculiar date format behavior when replacing parts of date | Excel Discussion (Misc queries) | |||
Date problem | Excel Worksheet Functions | |||
How to do a peculiar sort? | New Users to Excel | |||
A peculiar PDF from Excel problem | Excel Discussion (Misc queries) |