 | 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 | |
 | Rate this: ( 3/5 from 1 vote)
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 |
 | Rate this: ( 3/5 from 1 vote)
Greet
|
| | Posted by tjvangelder on |