[Dba-office] Excel formatting question

Susan Harkins ssharkins at gmail.com
Thu Mar 12 08:04:52 CDT 2015


Gustav, thanks -- that would be an option for display purposes at least.
Thanks for the alternative.

Susan H.

On Thu, Mar 12, 2015 at 8:53 AM, Gustav Brock <gustav at cactus.dk> wrote:

> Hi Susan
>
> You can use an expression:
>
>     =Format([YourNumber], IIf(Fix([YourNumber]) = [YourNumber], "0",
> "0.##"))
>
> /gustav
>
> -----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.
>
> _______________________________________________
> Dba-office mailing list
> Dba-office at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-office
>


More information about the Dba-office mailing list