View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Maki Maki is offline
external usenet poster
 
Posts: 30
Default How to remove automated rounding?

Hi

An invoice template I downloaded seems to do the rounding of sum to nearest
5 or 0; ex. Sum of $660.48 and $4816.38 shows as $5476.85. I don't need this
type of rounding as I'm not dealing in cash. How can I rectify this? Format
CellNumberCategory is Custom and Type is
_($*#,##0.00_);_($*#,##0.00_);_($*"-"??);_(@_)
I don't understand the syntax either.

Thanks for help.
--
Maki @ Canberra.AU