I understand that excel will only work to the 15th persision and have adjusted my workbook accordingly to correctly display numbers going forward.
I would like to change the few hundred enteries that have already been entered on a previous date to show the correct values. Simply changing the column to 'text' or setting the precision as displayed does not seem to change those numbers.
1.In Excel 2013 and 2010, click File, and then Options, and then click the Advanced category.
2.In the When calculating this workbook section, select the workbook you want, and then select the Set precision as displayed check box.
Any ideas? Or am I stuck with a bunch of 'XXXXXXXXXXXXXXX0'