[Dba-office] Excel formatting question

[Susan Harkins]

A reader wants to format values to display thousands separator (no
problem). His values will be whole numbers, mixed, and decimal values. He
wants to display whole numbers without a decimal value or trailing 00s
while accommodating decimal values. He's done it with two conditional
formatting rules, but was wondering if a custom format might work. I can't
come up with one -- how about you guys? I'm stumped, but maybe I'm just
making it too hard. Completely blank.

Susan H.