[Dba-office] Excel formatting question

Susan Harkins ssharkins at gmail.com
Thu Mar 12 07:36:36 CDT 2015


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.


More information about the Dba-office mailing list