Home |
Search |
Today's Posts |
#1
|
|||
|
|||
where is the excel template located?
Where is the default excel (office 2003) template located? I suspect I
have somehow modified mine. I have a problem exporting a report from MYOB into excel in that the date appears in the US format for the first 56 rows, and then the Australian format for the remaining rows. I have all settings as far as I can see in the computer set to Australian format. Even when I try and change the date format to Australian on the first 57 rows the display will not change to Australian format. I have tried clearing all formats and reformatting it but it still will not change (in these first 57 rows). The problem seems to be confined to my computer as I have tested other computers in our office without any problems. |
#2
|
|||
|
|||
Where is the default excel (office 2003) template located?
Excel does not natively have a default template. The default workbook you get on starting Excel is not based on any file on disk (natively). You can create a default template however and Excel will base new workbooks (and the startup workbook) on it. If you had one its name would be BOOK.XLT and it would likely be found at: C:\Documents and Settings\<user name\Application Data\Microsoft\Excel -- Jim "Doug McKean" wrote in message ... | Where is the default excel (office 2003) template located? I suspect I | have somehow modified mine. | | I have a problem exporting a report from MYOB into excel in that the | date appears in the US format for the first 56 rows, and then the | Australian format for the remaining rows. I have all settings as far as | I can see in the computer set to Australian format. Even when I try and | change the date format to Australian on the first 57 rows the display | will not change to Australian format. I have tried clearing all formats | and reformatting it but it still will not change (in these first 57 | rows). The problem seems to be confined to my computer as I have tested | other computers in our office without any problems. |
#3
|
|||
|
|||
I left off the XLSTART. That should be:
C:\Documents and Settings\<user name\Application Data\Microsoft\Excel\XLSTART -- Jim "Jim Rech" wrote in message ... | Where is the default excel (office 2003) template located? | | Excel does not natively have a default template. The default workbook you | get on starting Excel is not based on any file on disk (natively). You can | create a default template however and Excel will base new workbooks (and the | startup workbook) on it. | | If you had one its name would be BOOK.XLT and it would likely be found at: | | C:\Documents and Settings\<user name\Application Data\Microsoft\Excel | | -- | Jim | "Doug McKean" wrote in message | ... || Where is the default excel (office 2003) template located? I suspect I || have somehow modified mine. || || I have a problem exporting a report from MYOB into excel in that the || date appears in the US format for the first 56 rows, and then the || Australian format for the remaining rows. I have all settings as far as || I can see in the computer set to Australian format. Even when I try and || change the date format to Australian on the first 57 rows the display || will not change to Australian format. I have tried clearing all formats || and reformatting it but it still will not change (in these first 57 || rows). The problem seems to be confined to my computer as I have tested || other computers in our office without any problems. | | |
#4
|
|||
|
|||
Just a guess....
I don't think it has anything to do with any of your templates. I'm guessing that when you imported your data from MYOB, the data that looked like valid dates changed to dates--but the ones that don't look like dates, didn't get changed and were brought in as text. If one of your dates looks like: 01/02/03 in MYOB (I don't use it) Check to see if that date still represents the same date in Excel. Format that date in a non-ambiguous format: mmmm dd, yyyy and see if you really got: January 02, 2003 or February 03, 2001 or what. If all your "Dates" imported from MYOB can be brought in as text, you'll be better off. You'll be able to select that column of dates and do: data|text to columns choose the correct date format (ymd, dmy, mdy,...) and it should work. I don't know if MYOB works that way, though--but I wouldn't trust the dates -- especially if some were converted to dates and some weren't. ====== Excel's template file for new workbooks/worksheets is buried into the program (and some registry settings). But you can override those defaults by creating a book.xlt (or sheet.xlt) and storing it in your XLStart folder.) Doug McKean wrote: Where is the default excel (office 2003) template located? I suspect I have somehow modified mine. I have a problem exporting a report from MYOB into excel in that the date appears in the US format for the first 56 rows, and then the Australian format for the remaining rows. I have all settings as far as I can see in the computer set to Australian format. Even when I try and change the date format to Australian on the first 57 rows the display will not change to Australian format. I have tried clearing all formats and reformatting it but it still will not change (in these first 57 rows). The problem seems to be confined to my computer as I have tested other computers in our office without any problems. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Can not download excel template" | Excel Discussion (Misc queries) | |||
how do I change an excel template into a "workbook" | Excel Discussion (Misc queries) | |||
Excel Template fails to open??? | Excel Discussion (Misc queries) | |||
How do I auto number cells in an Excel template? | Excel Discussion (Misc queries) | |||
How do I assign sequential numbers in an Excel 2003 PO template? | Excel Worksheet Functions |