Stock Forum

Discuss value investing stock ideas

 You must be logged in to post
Search Forums:


 






Wildcard Usage:
*    matches any number of characters
%    matches exactly one character

Home Report Errors Decimal problem

Decimal problem
Page:   1  
No Tags
UserPost

6:41 pm
April 7, 2010


Jae Jun

Admin

posts 1336
2

Sure. That's an easy fix. You have to change it to US settings.

Is your computer set to US language/region settings?

http://www.oldschoolvalue.com/…..lculations

http://www.oldschoolvalue.com/…..h-version/

6:28 pm
April 7, 2010


stefw007

New Member

posts 1
1

Hi Jae,

I downloaded your spreadsheet yesterday, had a few problrmd but I've solved most of them. The problem now is that the stock prices are all off by 1000; i.e. for example the price for EMC shows 1,852.OO when it should be 18.52. I have a european excel 2007 and I've set the language settings to english and french and it doesn't work and I've also set the decimal and thousands separator all possible ways and it won't work.

Can you help here ?

Thanks
No Tags
Page:   1  


About the Stock Valuation Software forum

Most Users Ever Online: 147

Currently Online:
9 Guests

Currently Browsing this Topic:
1 Guest

Forum Stats:

Groups: 4
Forums: 40
Topics: 694
Posts: 3680

Membership:

There are 868 Members
There have been 8 Guests

There is 1 Admin
There are 3 Moderators

Top Posters:

somrh – 273
Graeme – 122
zehua – 96
valueinvestortoday – 75
nell – 67
krackerjack121 – 67

Recent New Members: kalidas, NathanB21, jademan10, romans122, vincentbston, mrpenguin

Administrators: Jae Jun (1336 Posts)

Moderators: Jae Jun (1336 Posts), VANYA (1 Post), djsun (0 Posts)