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