Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Setting the date format
All,
I have changed the date formatting of some cells through dd-mmm-yyyy, which results in dates like 18-nov-2008, which is exactly what I am trying to achieve. However, the value of the cell is 11/18/2008, but I want to fill in 18/11/2008. Obviously, this should result in 18-nov-2008 Could someone tell me how to solve this? Thanks in advance, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting Excel cell format | Excel Worksheet Functions | |||
I need help in setting my paper in apa format in microsoft | Excel Discussion (Misc queries) | |||
Need help setting up weekly mail-merge format | Excel Discussion (Misc queries) | |||
Setting format properties when opening Worksheet | Excel Worksheet Functions | |||
need help setting a simple format to keep rent. | New Users to Excel |