answersLogoWhite

0

Go to Format cells and then number and at the very bottom there is Custom. Pick one of the existing custom formats for date and then type in dd-mmm-yy and any date that is selected will be converted into that format.

Go to Format cells and then number and at the very bottom there is Custom. Pick one of the existing custom formats for date and then type in dd-mmm-yy and any date that is selected will be converted into that format.

Go to Format cells and then number and at the very bottom there is Custom. Pick one of the existing custom formats for date and then type in dd-mmm-yy and any date that is selected will be converted into that format.

Go to Format cells and then number and at the very bottom there is Custom. Pick one of the existing custom formats for date and then type in dd-mmm-yy and any date that is selected will be converted into that format.

Go to Format cells and then number and at the very bottom there is Custom. Pick one of the existing custom formats for date and then type in dd-mmm-yy and any date that is selected will be converted into that format.

Go to Format cells and then number and at the very bottom there is Custom. Pick one of the existing custom formats for date and then type in dd-mmm-yy and any date that is selected will be converted into that format.

Go to Format cells and then number and at the very bottom there is Custom. Pick one of the existing custom formats for date and then type in dd-mmm-yy and any date that is selected will be converted into that format.

Go to Format cells and then number and at the very bottom there is Custom. Pick one of the existing custom formats for date and then type in dd-mmm-yy and any date that is selected will be converted into that format.

Go to Format cells and then number and at the very bottom there is Custom. Pick one of the existing custom formats for date and then type in dd-mmm-yy and any date that is selected will be converted into that format.

Go to Format cells and then number and at the very bottom there is Custom. Pick one of the existing custom formats for date and then type in dd-mmm-yy and any date that is selected will be converted into that format.

Go to Format cells and then number and at the very bottom there is Custom. Pick one of the existing custom formats for date and then type in dd-mmm-yy and any date that is selected will be converted into that format.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

How do you show today's date in a cell in Excel?

Format / Cells / Date


How do you change 20130113 to a date format in Excel?

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


Why is your Excel numbers sum a 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.


How do I get rid of weird dates in Microsoft Excel 2007?

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.


In Excel dates are -aligned in the cell by default regardless of date format?

In Excel, dates are aligned to the right side of the cell by default, similar to numbers. This alignment is consistent regardless of the date format applied, such as short date, long date, or custom formats. The right alignment helps users quickly identify numerical data, including dates, which are stored as serial numbers in Excel. If you want to change the alignment, you can manually adjust it through the cell formatting options.


What is the shortcut to enter the date in Excel?

The formula is =NOW(). Ensure you format the cell to display the date format you want.


How do you change string data into date format in Excel?

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.


How do you time stamp a cell in Microsoft Excel?

You do not. Excel does not record the change date of an individual cell.


What day did August 13 2002 fall on?

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.


How do you change date format?

go to the command prompt and give the date commandusing the proper format and then restart the computer


Excel color change if before date?

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


What is the excel now function?

=NOW() returns the current date and time. The way it appears on your spreadsheet depends on how you format the cell.