First you need to extract the 3 parts from it for the year, month and day. After that you can use the DATE function to make it into a date. You can then format that cell into a date format. So if 20130113 is in cell A2, then in another cell you could use this formula:
=DATE(LEFT(A2,4),MID(A2,5,2),RIGHT(A2,2))
Format / Cells / Date
The cell has been formatted to be in date format. You just need to format the cell to show numbers. If a number is formatted as a date, it will show an actual date.
If you do not like how the dates are formatted, then change the date format of the cell to whatever style you would like to display.
The formula is =NOW(). Ensure you format the cell to display the date format you want.
An example is given below, where 111013 is in cell A1: =DATE(RIGHT(A1,2),MID(A1,3,2),LEFT(A1,2)) Further information is given in the related link.
You do not. Excel does not record the change date of an individual cell.
go to the command prompt and give the date commandusing the proper format and then restart the computer
Type 13/8/2002 into a cell in Microsoft Excel, press enter, then right click with your mouse, choose Format Cells and change Date format to the one showing the day of the week. The answer is Tuesday.
It has to be done through conditional formatting. For example, if cell value <= 1/1/2003 then set the background colour to red. Example: Format-> Conditional formatting... if cell value <= 1/1/2003 Format... etc
=NOW() returns the current date and time. The way it appears on your spreadsheet depends on how you format the cell.
* 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.
Apply formatting to the cell that you want. There does not have to be anything in the cell when you apply the formatting. Then when you type a date in, it will show in the format you want.