Number Formatting when exporting to merge file

[DrWill]

Hi All,

I am running FM 4. I have number field showing properly on the FM layouts, but when I export I get raw data. Example: The layout show $10.00, when I export to merge file, (merging to Word 2003)I see "10". Likewise I have a Interest Rate field shows 15% in FM layout, but exports as .15

I have a currency that show $ 15.12 in FM, but exports as 15.37158176875. Is there a way to format the data so when I merge to the word doc it is formatted properly.

Thanks for any and all help.

Dave

[comment]

Have you tried choosing the 'Format output using current layout' option when exporting?

[DrWill]

That worked perfectly. Thanks a mill