I am trying to mail merge from an Excel spreadsheet in Excel 2002. Some of the fields in excel have values that I have changed to precision as displayed. A value of 834.90 came across as a value of 834.899999999. Even when I went back into the spreadsheet and manually changed the value to 834.9, it still comes across as 834.89999999. How do I change the formating in the table so that it reflects commas and two decimal places. I am able to do formulas on other numbers in the table that add numbers together and those will format properly. What I need to do is to format stand alone numbers.
Reply With Quote