See the following shot:
Notice that the prices shows as 117.99000000000001 instead of $117.99
Here is the original data in Excel:
Where you can see how I have formatted it.
First of, the number is indeed 117.99. That is correct. I don´t know how the 0.000000000000001 got added on. But whatever.
Even if the number WERE 117.99000000000001, there must be a way either in Word or Excel to round that to two decimal places.
What am I doing wrong? It appears like this for every record in the database.