I have an Excel workbook with raw numeric data that probably originated as FLOAT data in a database. Looking at the xl\worksheets\sheet1.xml doc inside the XLSX shows values like this (abbreviated to just the column of interest);
<c r="E2" s="3"><v>428315</v></c>
<c r="E3" s="3"><v>0</v></c>
<c r="E4" s="3"><v>3167839.84</v></c>
<c r="E5" s="3"><v>3050037.97</v></c>
<c r="E6" s="3"><v>2926514.28</v></c>
<c r="E7" s="3"><v>2800695.64</v></c>
<c r="E8" s="3"><v>2668935.5699999998</v></c>
<c r="E9" s="3"><v>2534727.5299999998</v></c>
<c r="E10" s="3"><v>2394350.12</v></c>
<c r="E11" s="3"><v>2251364.64</v></c>
<c r="E12" s="3"><v>2101973.2000000002</v></c>
<c r="E13" s="3"><v>1949806.21</v></c>
<c r="E14" s="3"><v>1790987.69</v></c>
<c r="E15" s="3"><v>1629218.48</v></c>
<c r="E16" s="3"><v>1460542.84</v></c>
<c r="E17" s="3"><v>1288733.3799999999</v></c>
<c r="E18" s="3"><v>1109752.94</v></c>
<c r="E19" s="3"><v>0</v></c>
<c r="E20" s="3"><v>182305.72</v></c>Some of these values are clearly imprecise, i.e. 2668935.5699999998 instead of 2668935.57 in cell E8. When I look at the worksheet in Excel how do I make Excel display the raw data, i.e. the full imprecise value and not the rounded value? I've tried all of the standard format categories, none of which do what I want.
The reason for wanting to display raw data is that when Excel sums the values it uses the raw data, not the displayed figure, so differences arise. I'm aware of the Precision as Displayed setting, but this isn't what I want - the SUM is correct, I just want the screen to reflect what is being summed.
Edit I've created a sample file to demonstrate the issue. This file includes the raw data above and a few more rows for good measure. If you can't see the raw data (i.e. the value 2668935.5699999998 in cell A8) then look at sheet1.xml inside the xlsx to confirm it really is there. If you don't know about the XLSX file format then start here.
81 Answer
Try inserting a apostrephe (') in the beginning of the cell, this will show you the raw data within the cell.
You could also round each term before summing it using the Round function.
7
