Weird 'Theoretical Change and Optimal' output

Excel Help for Weird 'theoretical Change And Optimal' Output in Excel Portfolio Optimization Template

Weird 'theoretical Change And Optimal' Output

Rate this: (3/5 from 1 vote)

	I get some weird output in the Results sheet. In the columns Theoretical Change and Optimal I get percentages of weighting in millions %, see below. Theoretical Change Optimal Weighting Units Weighting Units         7970171,42% 14.282.994,48 7970177,00% 14.283.004,48 5,02% 11,53 0,1025273 23,53 8,72% 6,70 0,2823748 21,70 6742215,01% 4.497.432,19 6742227,00% 4.497.440,19 1043266,95% 1.479.055,83 1043274,00% 1.479.065,83 2092092,19% 2.132.102,62 2092102,00% 2.132.112,62 1769276,20% 1.343.748,48 1769292,00% 1.343.760,48 -3,50% -1,98 0,1420769 8,02 20,38% 13,95 0,2768502 18,95     100,00%   Do you know how I can fix this problem. Greetz, Thijs
	Posted by tjvangelder on 05 Jan 2007

Replies - Displaying 1 to 2 of 2

Order Replies By: Most recent | Chronological | Highest Rated

	That did the trick Rate this: (3/5 from 1 vote) Thanks! Now it's working all fine. Greet
	Posted by tjvangelder on 06 Jan 2007

	PC Regional settings Rate this: (3/5 from 1 vote) This behaviour can occur depending on the regional settings of your computer.  It is involved with the comma used to identify decimal places. If you try to adjust this to a point (.) using the Regional Settings option in the Control Panel, this will fix the problem.
	Excel Business Forums Administrator
	Posted by Excel Helper on 05 Jan 2007

Displaying page 1 of 1