It was one of the invoices at Office's official site.
http://office.microsoft.com/en-au/te...CT101172551033

I subsequently deleted cells from GST downwards and made SUBTOTAL into TOTAL
as I didn't need GST calculation afterall.

All I see in the SUBTOTAL cell is =SUM(D18:D30) and no formula for rounding...

Clicked on View tabMacrosView Macros but nothing shows.
--
Maki @ Canberra.AU


"T. Valko" wrote:

Where did you get the template? If it's a commercial product all of the
"important stuff" is probably hidden and protected from view.

Do you see *any* formula in those cells?

--
Biff
Microsoft Excel MVP


"Maki" wrote in message
...
Sorry, I haven't indicated what version I'm using.
It's Excel 2007 and that's part of the confusion. I can't navigate the
way
I could in the previous versions of Excel.

--
Maki @ Canberra.AU


"Maki" wrote:

It is definitely not formula, Biff, as I do not see =ROUND** or =MROUND.
Hmmm, how can I see what VBA codes are at work?
--
Maki @ Canberra.AU


"T. Valko" wrote:

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