| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Wont Change in Excel??!
Hi, I have been trying to formate a list of cells to display in the
dd/mmm/yy format when you type a date in the 9/6/04 format, I have tried applying this as a formula and also right clicking and changing the format date to dd/mmm/yy and it wont change. In the greyed bar it just leaves it as what ever i have typed, and if you click on different formats in the date list it still stays the same in this bar. Any ideas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Wont Change in Excel??!
Right click on the cell in question. Select Fromat cells, select Custom, not
date, select dd/mm/yy, and edit it to read dd/mmm/yy " wrote: Hi, I have been trying to formate a list of cells to display in the dd/mmm/yy format when you type a date in the 9/6/04 format, I have tried applying this as a formula and also right clicking and changing the format date to dd/mmm/yy and it wont change. In the greyed bar it just leaves it as what ever i have typed, and if you click on different formats in the date list it still stays the same in this bar. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mileage Claim Formula | New Users to Excel | |||
| How change the date format in the excel footer to dd mmm yy? | Excel Discussion (Misc queries) | |||
| date format in excel not in line with control panel regional setti | Excel Discussion (Misc queries) | |||
| Excel date field link to Word | Excel Discussion (Misc queries) | |||
| Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
Linear Mode
