| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Date format
Hi, I would like to put a date in a cell eg 1st march 2005 as 1/3 however it comes up with 3/1 (the month first) how can I change it. in control panel I have settings english(australian) thanks andrewm -- andrewm ------------------------------------------------------------------------ andrewm's Profile: http://www.excelforum.com/member.php...o&userid=23130 View this thread: http://www.excelforum.com/showthread...hreadid=384045 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format the "date" button for a header | Excel Discussion (Misc queries) | |||
| Conditonal Format with a date format | Excel Discussion (Misc queries) | |||
| How to format a date to a different format | Excel Discussion (Misc queries) | |||
| Date Format Question | Excel Discussion (Misc queries) | |||
| Problem with Date format from VBA code | Excel Discussion (Misc queries) | |||
Threaded Mode
