That format is not causing the rounding.

It's probably being rounded with a formula, or, it could be being done with
VBA code.

--
Biff
Microsoft Excel MVP


"Maki" wrote in message
...
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