Worked although 5% of 19.90 came out as 0.995. I want it to come out with less numbers after the decimal point as I will be adding up the 5% for a whole column to get the total. It's for eBay. The 5% is the final value fee eBay takes of the price and in this case the price is 19.90.

Worked although 5% of 19.90 came out as 0.995. I want it to come out with less numbers after the decimal point as I will be adding up the 5% for a whole column to get the total. It's for eBay. The 5% is the final value fee eBay takes of the price and in this case the price is 19.90.

Click to expand...

If you're using Numbers .. on the toolbar at the top of the screen there are 2 buttons .. one with 2 decimal places going to the left and one with 1 decimal going to the right .... that's the one you would use to reduce the number of decimal places in the answer. FYI .. 5% of 19.90 is 1.00

MacRumors attracts a broad audience
of both consumers and professionals interested in
the latest technologies and products. We also boast an active community focused on
purchasing decisions and technical aspects of the iPhone, iPod, iPad, and Mac platforms.