[Dba-office] Excel formatting question

Gustav Brock gustav at cactus.dk
Thu Mar 12 07:53:40 CDT 2015

Hi Susan

You can use an expression:

    =Format([YourNumber], IIf(Fix([YourNumber]) = [YourNumber], "0", "0.##"))


-----Oprindelig meddelelse-----
Fra: Dba-office [mailto:dba-office-bounces at databaseadvisors.com] På vegne af Susan Harkins
Sendt: 12. marts 2015 13:37
Til: dba-office at databaseadvisors.com
Emne: [Dba-office] Excel formatting question

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