How To Add New Date Format

By deafult Excel provides a lots of date format.But still some of the "local" date formats may not be available. Here is how to add a new date format:

1. Right click anywhere in the Excel sheet.
2. Go to Format Cells, go to the Number Tab, choose the last Custom option.
3. Here type your desired Date Format in the "Type" field. Here I have typed the dd-mm-yyyy format as an example. You can put the format you like.