hi i want to change formet cells in excel?

Question

In a cell formet cell is date formet
now i want to fill in date without slash
eg : now i am keying the a cell in 02021986 but value is 03/01/7436 i want to change date without slash

Answer 1

Right click the cell, go to format cell, and it'll be under the 'Number' tab. You can select 'Date' on the list on the left, then select the date format you want.



If you're using Excel 2007, it's under the 'Home' tab on the ribbon, in the 'Number' section; just select the cell and select 'Date' from the drop-down list. You can click 'More number formats' and you'll get more choice.

Answer 2

As someone has said, you can wrap text, or even merge a couple of cells together. To wrap the text, either right button of mouse, format cells, alignment, wrap text or, if you have already typed it, click in the cell, then click in the formula bar where you can see it and where you want the break in lines use Alt Enter to force the words onto next line within same cell. Excel is not really designed for long descriptions and as you yourself say it is 'comments' perhaps you should consider using a comment instead of normal cell (right button of mouse insert comment). The comment is then in a separate box which you can move away from the cell in case it covers other data in other columns, and right button of mouse to show or edit comment. However, as you appear to be using your spreadsheet purely for text, I would advise using a table in Word instead which is more used to text. In that case assuming 2.5 cm margins all the way round and you are working in A4 landscape your first column could be 2 cm wide to accommodate name and the second column 22cm wide to accommodate the comments. You can always cut and paste rather than retying if you want to try this. It would then automatically go into Word as a table and you just need to change the widths. Another advantage of using Word is, as you type in one cell, when it gets to the end margin of that particular cell the text would automatically wrap to the next line.

Answer 3

right-click the cell(s) and select format cells from the menu. click the number tab then click text.

if you have typed date with Slash, you can use Ctrl+h for replace / with Null

Answer 4

right-click the cell(s) and select format cells from the menu. click the number tab then click date. select the date format you want from the list then click ok.

Answer 5

Right Click

u get the option format

here u can give the format u want in the date

like

dd-mm-yyyy

or dd/mm/yyyy

or dd/MMM/yyyy MMM will be FEB MMMM= February



this should do the needful .

Answer 6

try to right click on the column that you want to change format... then click "format cells" then find date... and select the desired format for your date....





http://www.dvdavenue.tv/

Answer 7

If first answer doesn't give desired effect, try an apostrophe (') before the date, typing it in how you want it displayed.