Peculiar Date problem

G

Guest

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

Guest

One possibility, try hitting CTRL+`

The ` character can be found to the left of the 1 key.

Mike
 
G

Guest

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with date in user form 2
CountIF date problem 0
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Date Ranges with Gaps - Finding Corresponding Maximum 0
Cell Reformat 2
Microsoft Exel 2013 Conditional Formatting 0
Date problem 4
Zero problem with blank cell after automated data transfer 3

Top