Excel — Per-Cell Display: Integers vs Decimals

This post covers how to display one cell as an integer and another cell with 2 decimal places in Excel.

[01] By Default, Integers and Decimals Share the Same Decimal Setting

• The extracted data contains both integers and decimals.

• Format → Cell Format → Category (Number) → Decimal places (change to 2)

• With this approach, the format applies to every cell, so even integers display as 21.00.

• We need a way to keep integer values displayed without decimals while showing real numbers up to 2 decimal places.

[02] Conditional Formatting + MOD Function

• Select all target cells → Conditional Formatting → New Rule

• Use a formula to determine which cells to format
• Formula: mod(A1,1)<>0 → choose format

• Format: Number → Decimal places 2 → confirm all dialogs

• Result

• If the alignment between integers and decimals is distracting, format the integers as Number as well.

• Result