Results 1 to 2 of 2

Thread: MagicCell and currency formatting

  1. 11-22-2002, 06:58 PM #1
    pendarus
    pendarus is offline Registered User
    Join Date
    Nov 2002
    Posts
    2

    MagicCell and currency formatting

    Hi all!


    I have an access database with a field containing a monetary value. The value is stored in a number format with no decimal point, IE (23916 = $239.16). How can I format a cell with MagicCell and have the decimal in the right place? I have set the cell format as follows: "format=[currency]". The result I receive is (using my previous example) $23,916.00.


    Any help will be appreciated


    Thanks!
    Reply With Quote Reply With Quote
  2. 11-25-2002, 01:30 AM #2
    John
    John is offline Registered User
    Join Date
    Oct 2002
    Posts
    93
    Hi,

    Just modify your SQL statement to divide it by 100. Then it will output the right value.

    "Select fld / 100 as fld2 from table"

    Take care,
    John
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules