Issue 2343

1)Create a new spreadsheet.
2) In cell A1, enter a zero followed by a decimal point followed by the 
digit '5'. Hit 'tab'. This moves to cell B1. Enter the formula “=A1*2”. Hit 
tab, and watch as the formula gets the (correct) value “1”.
3)In cell A2, enter a decimal point followed by the digit '5'.Hit 'tab' to move 
to B2. As the cursor moves to cell B2, watch the AutoCorrect change the “.5” to 
the 1/2 character. In cell B2, enter the formula “=A2*2”. Hit 'tab'. Watch as 
the formula gets the (incorrect) value “0”.
The only reason I found this was that I was typing in an Excel spreadsheet that 
I forgot to put on a floppy when I left home. I got a different answer on the 
two spreadsheets. That was for grades in a class. The affected student has 
brought up his average since then, but at the time, losing half credit on an 
assignment meant he got a B at midterm instead of the A he deserved