| Home > Forum Home > Excel Portfolio Optimization Template > Entering Historical Returns Correctly > Number formats | Share |
Number formats
Excel Help for Number Formats in Excel Portfolio Optimization Template
| Forum Topic | Login |
Number Formats | Rate this: (4/5 from 2 votes) |
 | The Input data sheet formats the numbers for the first 100 rows with zero decimal places. If you look in the address bar, you will see the exact value to the number of decimal places that it was entered. This precise value is used for the optimization process and the results. It is simply a matter of refromatting the cells to your preference. | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
Excel templates and solutions matched for Number formats:Solutions: Convert Values |