FinanceTier 212 minintermediate

Rounding and Number Formats for Currency

Display currency to two decimal places without rounding the real stored value.

What you will learn

• Use a number format to control how a value displays, without changing the value itself
• Explain why ROUND()-ing every line item before totalling them drifts the total away from the true sum
• Recognise when rounding the underlying value is actually required, versus when only the display should change

Excel skills

Number Format vs ROUND · Number Formatting

The task

Unit prices carry a hidden third decimal. Calculate Line Total in D2 from the real (unrounded) unit price and quantity - then format columns B and D to DISPLAY two decimal places, without changing the stored values underneath.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free