where is the excel template located?

[Doug McKean]

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.

 

[Jim Rech]

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
| 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.

 

[Jim Rech]

I left off the XLSTART. That should be:

C:\Documents and Settings\<user name>\Application
Data\Microsoft\Excel\XLSTART

--
Jim
| >>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
| || 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]

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.)