| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to remove automated rounding?
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to remove automated rounding?
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to remove automated rounding?
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to remove automated rounding?
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to remove automated rounding?
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to remove automated rounding?
Are you sure that you've actually got 660.48 and 4816.38? If you have, for
example, 660.476 and 4816.376 and format them to show only 2 decimal places, they will show 660.48 and 4816.38, but their total is 5476.852, which again if formatted to 2 decimal places will show as 5476.85 If you're not dealing with cash, then you don't need the $ in the cell formatting, so change to Number, and to see what's happening, set it (at least temporarily) to more than 2 decimal places. -- David Biddulph "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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
| Automated Footer | Excel Discussion (Misc queries) | |||
| Automated Popups | Excel Worksheet Functions | |||
| Automated Archiving | Excel Discussion (Misc queries) | |||
| Automated Hyperlinking | Excel Worksheet Functions | |||
Hybrid Mode
