Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Location
    Philadelphia
    Posts
    15

    Unanswered: currency format - no decimal points

    is there a way to use currency format:

    Format([AmountGranted],"Currency"

    and not show decimal points?

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    No. You'll have to define your own custom format ...

  3. #3
    Join Date
    Aug 2003
    Location
    SW Ohio
    Posts
    198

    Re: currency format - no decimal points

    Originally posted by phillystyle123
    is there a way to use currency format:

    Format([AmountGranted],"Currency"

    and not show decimal points?
    Format([AmountGranted],"$9,990")
    Jim P.

    Supoorting Oracle, MSSQL7, Sybase 8, & Pervasive. Confusion Reigns

  4. #4
    Join Date
    Jan 2003
    Location
    Philadelphia
    Posts
    15

    Thumbs up Re: currency format - no decimal points

    thanks jim p! perfect!!!!
    "he's strangely attractive - maybe it's the discolored tooth"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •