An Excel 2010 Bug???

[John Caines]

Hello All.
Something really really strange happening in my spreadsheet.
Example.
<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5" /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th></th><th>J</th><th>K</th><th>L</th><th>M</th><th>N</th><th>O</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">29</td><td style="font-weight: bold;text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #000000;;">£10,918.31</td><td style="font-weight: bold;text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;color: #FFFFFF;background-color: #000000;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #000000;;">£109.18</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;color: #FFFFFF;background-color: #000000;;"></td><td style="text-align: center;border-right: 1px solid black;border-left: 1px solid black;background-color: #000000;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #000000;;">£280.00</td></tr><tr ><td style="color: #161120;text-align: center;">30</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #000000;;">£11,027.50</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;color: #FFFFFF;background-color: #000000;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #000000;;">£110.27</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;color: #FFFFFF;background-color: #000000;;"></td><td style="font-weight: bold;text-align: center;border-right: 1px solid black;border-left: 1px solid black;background-color: #000000;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #000000;;">£102.50</td></tr><tr ><td style="color: #161120;text-align: center;">31</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #000000;;">£11,137.77</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;color: #FFFFFF;background-color: #000000;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #000000;;">£111.38</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;color: #FFFFFF;background-color: #000000;;"></td><td style="text-align: center;border-right: 1px solid black;border-left: 1px solid black;background-color: #000000;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #000000;;">£9.00</td></tr><tr ><td style="color: #161120;text-align: center;">32</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #000000;;">£11,249.15</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;color: #FFFFFF;background-color: #000000;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #000000;;">£112.49</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;color: #FFFFFF;background-color: #000000;;"></td><td style="font-weight: bold;text-align: center;border-right: 1px solid black;border-left: 1px solid black;background-color: #000000;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #000000;;">£160.00</td></tr></tbody></table><p style="width:7.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5;color: #161120">Daily Targets</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #BBB"><thead><tr style=" background-color: #DAE7F5;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J29</th><td style="text-align:left">10918.3128044588</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J30</th><td style="text-align:left">11027.4959325034</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J31</th><td style="text-align:left">11137.7708918285</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J32</th><td style="text-align:left">11249.1486007467</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L29</th><td style="text-align:left">109.183128044588</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L30</th><td style="text-align:left">110.274959325034</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L31</th><td style="text-align:left">111.377708918285</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">L32</th><td style="text-align:left">112.49</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">N29</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O29</th><td style="text-align:left">280</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">N30</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O30</th><td style="text-align:left">102.5</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">N31</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O31</th><td style="text-align:left">9</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">N32</th><td style="text-align:left"></td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">O32</th><td style="text-align:left">160</td></tr></tbody></table></td></tr></table><br />

In All the cells J29 :O32 they all display Currency (As I formatted them that way.
But,,,, I wanted to use some conditional formatting and it wasn't working,,, but I can now see why, but don't know how to fix this,, I think it's a bug?

Example:
Cell J29 Displays £10,918.31 (Which is correct & how I want it(,, but in the formula bar it shows, 10918.3128044588
??????????????
The only cell that displays properly in its cell & in the formula bar is cell L32 which shows £112.49 in the cell, & 112.49 in the formula bar.
THIS IS THE ONLY CELL I COULD GET THE CONDITIONAL FORMATTING TO WORK IN!!!
Please,,, can someone tell me how I can fix these long numbers to be just like the cell L32 please.

I have been doing a lot of copy/paste/merging across cells etc,, so maybe this was something to do with it?
Not sure.
Is there a solution please?
Many thanks
A very frustrated;
John Caines

 

[John Caines]

Hello All again,,,
after much hunting,,, I've come across a Excel Regular "daddylonglegs" who said;
===================================
If you use
Tools > Options > Calculation
then select "Precision as displayed"
then all numbers will become as per the displayed values.
Note: you can't reverse this so I suggest you save a copy before you try it......
===================================

I made a copy 1st, & I've just tried this,, it seems to work fine now.
My question though is,, how does this happen in the 1st place?
Anbody have any ideas?
As some cells were still ok,, but most weren't.........
A bug???