LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
MMS USA
 
Posts: n/a
Default Can't read Dutch written equations in excel files. Could before..

I've recently upgraded from the previous USA Office XP 2002 to USA Office XP
2003.

In office XP 2002 I was able to use our company's excel file that comes from
Holland. All the equations in the excel file are written in Dutch. Here's
an example:

=IF(+G21<"",IF(+G21<100,AFRONDEN.N.VEELVOUD(+G21+ 0.49,1),IF(+G21<1000,AFRONDEN.N.VEELVOUD(+G21+2.49 ,5),IF(+G21<10000,AFRONDEN.N.VEELVOUD(+G21+4.99,10 ),IF(+G21<20000,AFRONDEN.N.VEELVOUD(+G21+12.49,25) ,AFRONDEN.N.VEELVOUD(+G21+24.99,50))))),"")

Now, in Office XP 2003 the contents of this equation produces #NAME?. I
can't seem to find any type of language setting or addon package that
corrects this. Nor can I seem to find out what language changes have been
made between the two versions.

I've had multiple different installations of XP 2002 on different computers
all able to "translate" these equations so that tells me it wasn't unique to
just 1 install. How do I get XP 2003 to recognize these equations?

Any help would be greatly appreciated.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
How do I read Pocket Excel files from Excel billywhizz Excel Discussion (Misc queries) 0 January 23rd 05 06:47 PM
sharing/using/saving Excel 2002 files in Excel 2003 maze2009 Excel Discussion (Misc queries) 0 January 20th 05 07:27 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM
Is there a converter to read Quattro pro files on Excel 2002? Suseel Menon Excel Worksheet Functions 2 January 6th 05 05:38 AM


All times are GMT +1. The time now is 07:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"