I have developed a macro in English on a Swedish Mac. The macro runs on a a Mac used in France with Excel in French. All the (many) Subroutines work very well... but one. I used the formula "=VALUTA(123,4567)" [Swedish for currency] so that it should truncate to 2 decimals and then convert to text. The corresponding French formula is "=DEVISE(123,4567)", which I now use. I fill a whole column with this formula with the VBA-macro but the result is "NOM?" [name?]; one would think Excel does not recognize DEVISE(). However, and this is the real question, if I mark any of these cells and press RETURN (manually, that is) it recognizes the formula and prints 123,45!!! I am quite frustrated. Any pointers towards a solution would be greatly appreciated. Thank you. What I really want to do is to take two values, 23.4567 and 12.345678, truncate the decimals and concatenate to a line like this: "Weight 23.45 and Length 12.34" (not necessarily round up/down, just truncate).
