Forum | Old School Value

	You must be logged in to post

Home Forum Questions Values 100 times of using Swedish version

Values 100 times of using Swedish version

Page: 1

User

Post

6:42 pm
December 27, 2009

Jae Jun

Admin

posts 680

Glad you figured it out.

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

7:04 am
December 27, 2009

bjoel

Member

posts 3

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

6:49 am
December 27, 2009

bjoel

Member

posts 3

Hi!

Just purchased and downloaded the spreadsheet.

What version of excel you are using = Microsoft Office 2007, Swedish version
Which spreadsheet you are using = 05yr_OSV_Stock_Valuation_v6.1.0.xls
The exact FULL path of the add-in you unzipped the files to C:\SMF
Screenshots of the directory containing the add in
What step of the install guide is not working
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

Page: 1

About the Old School Value forum	Forum Timezone: Etc/GMT+7
Most Users Ever Online: 110 Currently Online: 14 Guests Currently Browsing this Topic: 1 Guest	Forum Stats: Groups: 4 Forums: 39 Topics: 349 Posts: 1560	Membership: There are 369 Members There is 1 Admin There are 3 Moderators	Top Posters: zehua – 88 DrSues02 – 45 krackerjack121 – 35 Sid – 33 dmop12 – 33 ankitgu – 30
Recent New Members: almostfriday, bbqrooster, qook25, jhlee, VInvestor, kevibak
Administrators: Jae Jun (680 Posts) Moderators: Jae Jun (680 Posts), VANYA (1 Post), sjmsoftech (0 Posts)

About the Old School Value forum

Forum Timezone: Etc/GMT+7

Most Users Ever Online: 110

Currently Online:
14 Guests

Currently Browsing this Topic:
1 Guest

Forum Stats:

Groups: 4
Forums: 39
Topics: 349
Posts: 1560

Membership:

There are 369 Members

There is 1 Admin
There are 3 Moderators

Top Posters:

zehua – 88
DrSues02 – 45
krackerjack121 – 35
Sid – 33
dmop12 – 33
ankitgu – 30

Recent New Members: almostfriday, bbqrooster, qook25, jhlee, VInvestor, kevibak

Administrators: Jae Jun (680 Posts)

Moderators: Jae Jun (680 Posts), VANYA (1 Post), sjmsoftech (0 Posts)