Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date format in Excel Templates .xlt
Hello
My computer is set to ddmmyyyy and Excel.xls defaults as ddmmyyyy, but I have a template .xlt where the date format defaults as mmddyyyy. How do I reset .xlt to ddmmyyyy? Thanks -- David B |
#2
|
|||
|
|||
My post feels very lonely as nobody has responded. So I will answer my own
query. I have a utility that exports ACT! dates in ddmmyyyy to an excel template.xlt which calculates and sends the result back to ACT!. Format\cell\all the ddmmyyyy formats plus custom formats had no effect, template .xlt is immovably N American on mmddyyyy. ddmmyyyy outputs to .xlt were ok as long as the days fell in the 13 to 31 inclusive range. Days 1 to 12 calculated to mmdd. The solution I have found is to format .xlt as text which reads the ddmmyyyy input as sent. Formulas read the .xlt text cell contents as a ddmmyyyy date and calculate accurately. Can MS please have a look at template.xlt format facilities. Also, my experience is that you cannot back up excel.xlt while excel.xls is open without getting warnings about loss of data. Closing .xls enables warning free back ups of .xlt. -- David B "David B" wrote: Hello My computer is set to ddmmyyyy and Excel.xls defaults as ddmmyyyy, but I have a template .xlt where the date format defaults as mmddyyyy. How do I reset .xlt to ddmmyyyy? Thanks -- David B |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format date in excel 2000 like '31st January 2005' | Excel Discussion (Misc queries) | |||
Keeping date format of a field inserted from an excel database | Excel Worksheet Functions | |||
Conditonal Format with a date format | Excel Discussion (Misc queries) | |||
Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) | |||
How do I change the default date format in an Excel Footer | Setting up and Configuration of Excel |