[ic] Price Format
Wed, 17 Jan 2001 20:55:57 +0100
Mathew Jones wrote:
> I am having problems displaying the price of an item in the correct format
> even though it appears the way I want it in my SQL table. In my SQL db the
> price for example, would be $25,000. but when I pull up the book info, it
> displays in interchange as $25.00
> Is there a setting I need to change in the catalog.cfg, or a special tag I
> need to place around the [item-price] tag and other price related tags such
> as total, subtotal, extension??
The best way is to format all price in your SQL talble without any
character like $. Make a test and replace $25,000 to 25,000.00 or
25000.00 and see what you get.