Formating numeric values to be exported

[adalante]

I've made a simple database to create inventory item records for import into our accounting system. The database calculates various margins and sales prices for some currency exchange rates. I have a couple of numeric fields that need to be output with 2 decimal places to a TAB delimeted file. I have created a layout with all required fields and have formatted the numeric fields with 2 decimal places then use a script to go to that layout, create the file then export the items. Trouble is the numeric values have upto 6 decimal places which the accounting package doesn't like.

I understood that FMP formatted the numeric field's output based on the current layout, this doesn't seem to be the case fo me. Is there a way to force the numeric format to 2 decimal paces when exporting?

Many thanks

[adalante]

I found the check box that formats the data per the layout, all good now.