Yes, you can decrease the decimal places by two in Excel. But if you apply Decrease Decimal twice on a cell that already has formatting-only rounding, you’re not changing the real value—just hiding more digits.
The Setup
Last Friday, Maya from Finance sent me a raw export from their ERP: invoice line items with unit prices pulled straight from SAP. The numbers came in with 6 decimals—like 149.876543 or 22.000000. She needed them shown as dollars and cents (2 decimals) for the client-facing report, but also wanted the underlying values truncated—not rounded—for tax reconciliation.
| Invoice ID | Product | Unit Price (Raw) | Vendor |
|---|---|---|---|
| INV-7821 | Wireless Headset Pro | 89.987654 | SoundCore Ltd |
| INV-7822 | USB-C Dock Station | 124.555555 | NexusGear Inc |
| INV-7823 | Ergo Keyboard TKL | 72.000000 | TypoLab Corp |
| INV-7824 | Noise-Cancelling Earbuds | 54.321987 | Aurora Audio |
| INV-7825 | Mechanical Switch Set | 31.654321 | ClickWorks LLC |
| INV-7826 | Magnetic Cable Pack (3) | 29.999999 | VoltLink Systems |
| INV-7827 | Screen Protector Bundle | 18.123456 | ClearView Tech |
| INV-7828 | Carrying Case Slim | 45.000000 | PackLite Co |
The Challenge
Maya asked: “Can’t I just click ‘Decrease Decimal’ twice in the Home tab?” She did—and got 89.98, 124.55, 72.00. Looks right. But when she multiplied those displayed values in another sheet? Totals were off by $0.03 across 200 rows. Why? Because Decrease Decimal only changes display—it doesn’t alter the stored value. Her formula used the full 89.987654, not 89.98. She needed true truncation to two decimals—not visual rounding.
And here’s what most miss: ROUND() rounds. ROUNDDOWN() truncates. But neither decreases decimals “two times.” That phrase is misleading—it’s really about reducing precision *by two decimal places*, not applying an action twice.
Walking Through It
We’ll fix column C (Unit Price Raw), starting at C2. First, let’s see what happens if you misapply Decrease Decimal:
| Cell | Before | After 1× Decrease Decimal | After 2× Decrease Decimal |
|---|---|---|---|
| C2 | 89.987654 | 89.98765 | 89.9876 |
| C3 | 124.555555 | 124.55555 | 124.5555 |
See the problem? It’s removing *one digit per click*, not one decimal place. Clicking twice removed two digits total—not two decimal places. To go from 6 to 2 decimals, you need four clicks. But again—that’s cosmetic.
For real control, use =ROUNDDOWN(C2,2) in D2. This forces truncation to exactly 2 decimal places—no rounding. Copy down to D9.
💡 Counterintuitive tip: If you need to keep the original column but show clean values, don’t overwrite. Insert a new column (right-click column D → Insert), type the formula there, then hide column C if needed. Never delete raw data—even if it looks messy.
Keyboard shortcut: Select D2:D9, then press Alt + H + 9 to format as Currency with 2 decimals—this won’t change values, but makes your ROUNDDOWN results look polished next to headers.
The Result
Here’s what D2:D9 looks like after =ROUNDDOWN(C2,2):
| Invoice ID | Product | Truncated Price | Vendor |
|---|---|---|---|
| INV-7821 | Wireless Headset Pro | 89.98 | SoundCore Ltd |
| INV-7822 | USB-C Dock Station | 124.55 | NexusGear Inc |
| INV-7823 | Ergo Keyboard TKL | 72.00 | TypoLab Corp |
| INV-7824 | Noise-Cancelling Earbuds | 54.32 | Aurora Audio |
| INV-7825 | Mechanical Switch Set | 31.65 | ClickWorks LLC |
| INV-7826 | Magnetic Cable Pack (3) | 29.99 | VoltLink Systems |
| INV-7827 | Screen Protector Bundle | 18.12 | ClearView Tech |
| INV-7828 | Carrying Case Slim | 45.00 | PackLite Co |
What Could Go Wrong
Here are three real issues I saw last week—each traced to how people interpret “decrease decimal two times”:
| Symptom | Cause | Fix |
|---|---|---|
| Numbers like 29.999999 become 30.00 instead of 29.99 | Using ROUND instead of ROUNDDOWN | Swap =ROUND(C6,2) → =ROUNDDOWN(C6,2) |
| Formula shows #VALUE! after pasting | Text-formatted numbers in column C (e.g., '89.987654' with apostrophe) | Use =VALUE(C2) inside ROUNDDOWN: =ROUNDDOWN(VALUE(C2),2) |
| D2 shows 89.98 but SUM(D2:D9) returns 515.578 instead of 515.57 | Formatting applied to D2:D9 *after* formula entry—but cells still hold full precision because formatting doesn’t alter values | Don’t rely on formatting alone. Use ROUNDDOWN *and* verify with =ISNUMBER(D2) + check formula bar value |
