Forum | Old School Value http://www.oldschoolvalue.com/forum/questions/values-100-times-of-using-swedish-version/ Simple:Press Forum Version 4.2.2 Forum | Old School Value http://www.oldschoolvalue.com/forum/questions/values-100-times-of-using-swedish-version/#p452 Questions http://www.oldschoolvalue.com/forum/questions/values-100-times-of-using-swedish-version/#p452 Glad you figured it out.

Number settings in windows has to be set to US dollars.

]]> Sun, 27 Dec 2009 18:42:40 +0000 Forum | Old School Value http://www.oldschoolvalue.com/forum/questions/values-100-times-of-using-swedish-version/#p447 Questions http://www.oldschoolvalue.com/forum/questions/values-100-times-of-using-swedish-version/#p447 I seemed to solve this myself, by going into the Windows control panel and changing the regional settings (in Swedish: "Nationella inställningar") to use the dot as the decimal separator and the comma as the thousand separator.

Now I'm a happy camper.  :)

]]> Sun, 27 Dec 2009 07:04:46 +0000 Forum | Old School Value http://www.oldschoolvalue.com/forum/questions/values-100-times-of-using-swedish-version/#p446 Questions http://www.oldschoolvalue.com/forum/questions/values-100-times-of-using-swedish-version/#p446

Hi!

Just purchased and downloaded the spreadsheet.

  1. What version of excel you are using = Microsoft Office 2007, Swedish version
  2. Which spreadsheet you are using = 05yr_OSV_Stock_Valuation_v6.1.0.xls
  3. The exact FULL path of the add-in you unzipped the files to C:\SMF
  4. Screenshots of the directory containing the add in
  5. What step of the install guide is not working
  6. Whether you have checked out the SMF add in Yahoo group = searched but did not find anything relevant

The basic installation seems to work fine, but all numbers seem off by a factor 100.  For instance, when looking at figures for Microsoft MSFT on the Summary page, I get a market cap of 27 525 000 and a 52 week high of 3100,00.  Graphs and numbers all over seems off by this factor too

I guess this has something to do with different decimal separators (comma is used in swedish excel) but I do now know enough excel to tell how to fix this.  Any hints?

/Björn

]]> Sun, 27 Dec 2009 06:49:55 +0000