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??

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??

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??

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??

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