0
* Select the cell or range of cells you want to format.
* Right click and choose 'format cells'.
* Under the 'Number' tab - in the category menu choose 'custom'
* In the 'Type' box write 'dd/mm' - to format a date of say 02/07/2011 as 02/07.
* If you prefer it to show 02/July then change it to 'dd/mmmm'.
* 'Ok' the change.
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
What will the underline format underline in excel?
only the characters in the cell
The underline format will underline . in excel?
only the characters in the cell
The underline format will underline in excel?
only the characters in the cell
How do you format a cell in micro soft excel to automatically update the day month and year every time it opens?
Type this formula in the cell (including the 'equals' signand the empty parentheses):=TODAY()Then, make sure the date in your computer is correct.That's the only way Excel knows the date.
What is the format that underlines only the character in a cell not the entire cell?
If this is an Excel question, you can underline words the same as in MS Word - use the 'U' icon or 'Format-font-underline'. The format is called 'underline', btw.
What does selecting a cell do in Excel?
If you select a cell, it makes it active allowing you to do things like type something into it or format it. You can also select more than one cell at a time. In that case, only one is the active cell, but you can do things like format the cells or copy them or paste something into. Basically, if you want to do anything to a cell, it has to be selected first.
How do you change a date to years and months in Excel?
You can format a date so that it only shows month and year, but leaves out the day. Select the date cell and open the Format Cells dialog, by pressing Ctrl - 1. Choose custom and then you can type mm-yyyy as the format to show just the month and year for your date.
What button does excel display after the paste button is clicked?
It displays several options about what you can paste, like everything, format only, formulas only, special format, etc.
What is inactive cell in excel?
At any one time you can only be working on one cell in Excel, like when you are typing data. Even if you have many cells selected, only one can actually be used. That cell is the active cell. All other cells are inactive. So an inactive cell is any cell that is not the active cell.
How do you copy a protected cell in excel without removing the protection to another excel sheet?
Cell protection only kicks in when you protect the entire sheet. So for the cell to be protected, then the sheet has to be protected.
What copies format of source area but not the contents?
Use regular copy, then past only the format (paste format) to a cell.
Can the condition of a cell only be true using excel 2007?
No. The condition of a cell can be either true or false.
