| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
how do i change the format for excel to day-month
I am asked to change the format of a date that is day-month-year to format
the dates as day-month. It is to my understanding there is a certain formatting in doing this. Can you help? |
|
#2
|
|||
|
|||
|
Sure. Just select the cells, row, or column, and hit Format--Cells. Choose
date and see if the format you like is shown. If not, and you want something else, here's a short list: d = 1 dd = 01 m = 1 mm = 01 yy = 01 yyyy = 2001 dd-mm = 01-01 dd-mmm = 01-Jan and a wealth of others... ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "swy" wrote in message ... I am asked to change the format of a date that is day-month-year to format the dates as day-month. It is to my understanding there is a certain formatting in doing this. Can you help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can one change the font or format of a sheet name? | Excel Discussion (Misc queries) | |||
| How do I change date format? | Excel Discussion (Misc queries) | |||
| format cell to change color when copied | Excel Discussion (Misc queries) | |||
| How do I change format of all comments in worksheet? | Excel Discussion (Misc queries) | |||
| how to change the h:mm format to number? | Excel Worksheet Functions | |||
Hybrid Mode
