| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Forcing english date format
Hi I use a form that pulls in a range of dates from excel. I need date to be in 28/2/06 type format. Only trouble is every time I shut and reopen the workbook the date comes in as 02/28/06. To solve this I am currently having to go through control panel, regional settings,customise,date,and highlighting the longdate format dd:MM:yy (Which is already showing as active option) How can I force excel to use this format automatically? Nb the dates on the spreadsheet are already formatted to 28/02/06 This one has been causing me a headache for over 2 year now - I just discovered this forum so really hope someone knows the answer Cheers Steve -- Steve1154 ------------------------------------------------------------------------ Steve1154's Profile: http://www.excelforum.com/member.php...o&userid=31550 View this thread: http://www.excelforum.com/showthread...hreadid=512663 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Format - US to English | Excel Discussion (Misc queries) | |||
| Changing date format in a footer | Excel Discussion (Misc queries) | |||
| I cannot change the date format to English canada | Excel Discussion (Misc queries) | |||
| format date in excel | Excel Discussion (Misc queries) | |||
| Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
Threaded Mode
