-
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!
-
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
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
|
|