Question about Microsoft Office 2003 Basic Edition English (s55-00066) for PC

1 Answer

Excel not importing dates as given by accounting package

My computer regional settings for dates is dd/m/yy.
MYOB accounting is set the same.
When exporting a report to my new computer which has Office Basic Edition version 2003 it changes those dates with a day of less than 12 i.e. 01/9/07 to 09/01/07.
When exporting the same file to my other computer which has Office XP Small Business version 2002 the import is correct.
My email address is
Your assistance would be greatly appreciated.
Regards Ron Webster South Africa

Posted by on

1 Answer

Re: Excel not importing dates as given by accounting...

Dear Valanti,

This implies that basically the versions are causing the problem and there are compatibility issues with your program. I would suggest that you should copy the report files to a detachable media and transfer it to your new system because this is a one time process.

You can also install the same version on both PCs. You can also do following for tracking changes in documents:

  • In Word 2002 and 2003: Tools > Track Changes.
  • In Word 2000 and earlier versions: Tools > Track Changes > Highlight Changes. Tick Track Changes while editing.
If that was helpful, please press solved.

Posted on Nov 25, 2007

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

1 Answer

I need a formula length of service in DD/MM/YY on MS Excell

Format cells A1 and B1 to dates.

A1 is the first date
B1 is the 2nd date
C1 enter the formula below

=DATEDIF(A1,B1,"y")&" years "&DATEDIF(A1,B1,"ym")&" months "&DATEDIF(A1,B1,"md")&" days"


Jun 23, 2011 | Microsoft Excel for PC

1 Answer

'Print error #5'

MYOB requires that you have a default printer selected on your computer system. If no printer driver is installed, when opening a company file, a printer error #5 is displayed.

Highlight your Printer and go to File on then Menu bar/Set as default.and Turn off user account control if you're using vista. It's in your security center in the control panel. Turning this off should fix the printer error 5 issue .

Mar 03, 2010 | Myob Accounting Plus (BPJUBC00) for PC,...

1 Answer

In quickbooks pro 2007, the date format is mm/dd/yyyy

Hi, i am using windows 7 and clicked on start, control panel, regional and language, and then found my settings (was having same problem with quickbooks premier and the date set to US) and found i had accidently selected in the install of windows 7 [English-USA] instead of [English-Australia]. i altered two settings and now my quickbooks is working fine. whenever i searched for this on quicken help sites it did not indicate clearly how easy it was to fix this.

Oct 01, 2009 | Intuit QuickBooks Premier: Accountant...

1 Answer

Need a formula to calculate length of service in excel

You could do a simple +NOW-START DATE

It would depend on the format of your start dates - i.e YY, DD/MM/YY as to the results you get.

Do want the results in years, months, days?

Jun 05, 2009 | Microsoft Excel for PC

1 Answer

Calculation of end date in format dd/mm/yy

Assuming you put the start date in cell A1, put this formula:


in the cell where the result wanted to be appeared.

P.S.: If this information was helpful, please rate this solution.

Mar 12, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Input data

If you want to transfer your data into SAS, SPSS, or some other program, follow these guidelines:
The cells in Row 1 should contain the column's eventual data set name. Each name should be a relatively short and unique acronym that clearly identifies the data. It should begin with a letter and contain only letters, numbers, or an underscore ( _ ) where spaces would naturally fall. Avoid using special characters such as $, &, @, in variable names. Since each row represents the values from one subject, the first column(s) should contain one or more variables that give each subject a unique identifier. They become especially important if you need to merge two or more data files.
In Excel, data formats are defined for a range of cells rather than for a complete column. For this reason it is important that each entire column, including cells with missing or uncollected data, have one, and only one, format. Actually, you do not need to format the entire column, only the portion you will eventually use. Highlight that portion and select the appropriate format from the Format/Cells option. Do not select formats that will enter commas, dollar signs, or other visual enhancements. Numeric, text, and date formats (e.g. mm/dd/yy is often a good choice) are probably the only formats you'll ever need.
The "Split" option (under the "Window" pull-down menu) keeps the row of variable names and the columns of identifiers in view, whatever range of cells in the worksheet you may need to review. First place the cursor at the most extreme upper left-hand corner where data entry begins (e.g., the intersection of Row 2 and the column in the upper left-hand corner where data appear) and then select "Split" from this menu. For any row or column of the worksheet you move to, you'll know exactly which variables you are observing (column names) and their associated ID values (rows).
For versions of Excel later than 4.0, one file can contain multiple worksheets. By default, the tabs at the bottom of these sheets are supplied names ("sheet1," "sheet2," etc.). You can change these names by clicking this space with your mouse and entering a new name. Use the same conventions for first-row variable names: use a short acronym of the page contents that begins with a letter, use only letters or numbers, and enter the underscore ( _ ) where a space naturally falls.

Jan 05, 2009 | Sage Instant Accounts 8.0 (013604ug)

1 Answer

How to calculate total downtime of a perticulor ticket. for ex: if a perticulor ticket being opened three days before and the end time would be 4th or 5th day, so the ticket details would be containing,...

cell 1 = logged in date <mm/dd/yy>
cell 2 = logged in time <hh:mm:ss>
cell 3 = resolved date <mm/dd/yy>
cell 4 = resolved time <hh:mm:ss>
cell 5 = cell 4 + cell 3 - cell 2 - cell 1 <general format>
cell 6 = day(cell 5) <general format>
cell 7 = hour(cell 5)&":"&minute(cell 5)&":"&second(cell 5) <general format>

Nov 18, 2008 | Business & Productivity Software

1 Answer

Date format in quickbooks 7.4

If it's anything like Excel, someplace in the FORMAT menu should be options to allow you to change the date format. (Block off the cells, row, or column in question, click FORMAT in your toolbar.) You may have different country options or formatting choices within the date type.

Nov 15, 2007 | Intuit QuickBooks Premier: Accountant...

Not finding what you are looking for?
Microsoft Office 2003 Basic Edition English (s55-00066) for PC Logo

197 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides