Best Answer

more information required - what software package and/or operating system are you trying to do this on?

User Avatar

Wiki User

โˆ™ 2011-07-02 14:34:21
This answer is:
User Avatar
Study guides

What are advantages of Database Approach

What is a network that covers a large geographical area such as a city country or world

What is the worlds largest wan

What is a network server

See all cards
188 Reviews

Add your answer:

Earn +20 pts
Q: How do you add new custom date format like this
Write your answer...
Still have questions?
magnify glass
Related questions

How do you change number format?

Right-click and select format cell. Go to the section for number formats and select the format you like. If you do not like the format, you can change it to almost anything you like, including custom formats.

How do you enter a date in MS Excel?

You can use almost any format you like to enter the date. The key to using and viewing dates is the cell format. Right-click on the cel and select cell format. Then you can format the date to look almost any way you like.

In Excel can you create your own custom formats?

Yes. It is possible to create custom formats for things like dates, currencies and numbers etc. Type in some values you want to format first. Then go to the Format menu, click Cells, and you will be given a menu with various formats, the last of which is Custom. Often it is best to pick one of the existing formats first and then customise after that by going in to format again.

How can you convert time in 24hrs in Microsoft Excel 2010?

Press Ctrl-1 to open the Format Cells dialog box. Pick the Number tab, then the time, and then Custom and you can change how the time is displayed, like having it show with AM and PM instead of using a 24 hour style. So you can have 3:00PM or 15:00 for example. If you are then doing calculations you can use a custom format to show the hours as a total, to enable it to show above 24 hours, which would be useful for things like time sheets. The following custom format can do that: [h]:mm:ss

How do you find out what day of the week you were born?

There are many ways. On the internet it is very easy to find a calendar for the month you were born. Do a search for the month and year of your birth and you will get it. You can also use lots of software. For example, if you have a spreadsheet like Excel, put your date of birth into a cell, say cell A2. Then in another cell enter the following formula: =WEEKDAY(A2) That will give you a number between 1 and 7, which indicates what day of the week the date is. 1 is Sunday, 2 is Monday and so on. You could also go to Format Cells and format the date to a custom format using this structure: dddd dd mmmm yyyy The date will now display with the day of the week as a word.

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.

How do you find out what day of the week a certain date fell on?

There are many ways. There are lots of calculators on the internet that will do it. See the Weekday Calculator from linked below in the "Related links" section. For example, Feb 25th 1963 was on a Monday. You could also do a search of the month you are looking for and it will show you a calendar for it. You can use software to do it, like a spreadsheet. In Excel there are some ways of doing it. Say you typed the date into cell A2. Then in another cell type the following formula: =WEEKDAY(A2) That will give you a number between 1 and 7. Remembering that Sunday is the first day of the week, so it is 1, then you will know which day the date corresponds to. If you go into formatting, you can change the format of the date to show the day. Select the cell and go into formatting. It will be in date format. Then go to Custom Format at the bottom of the list and change it to this: dddd d mmmm yyyy This will show the full date with the day of the week and the month of the year for that date.

What is a date format in excel 2007?

It is the way you would like the date displayed when you view it. Here are some options: 01/12/2010 Decenber 13, 2009 1-Mar-54

What is meant by the term 'formating a cell' in Excel?

When you format a cell in Excel, you change the appearance of a number without changing the number itself. You can apply a number format (0.8, $0.80, 80%, etc) or other formatting (alignment, font, border, etc).

What do the 3 different sets of numbers on plant food cans mean example 15-4-12?

They are an expiry date. It sounds like that date is written in the British format: day-month-year.

How do you cite web in mla format?

To cite web in MLA format people must mention certain things like; Author's Last Name, First Name; Title of Page/Document; Title of the Web Site; Sponsoring Organization; Publication/Updated Date; Medium of Publication; Date of Access.

What is a writing format?

A writing FORMAT is what the writing looks like.

People also asked