I am creating a csv file from a report in baan. The problem I'm having is with the dollar value. If the dollar value is $475.00, when I open the csv file, it contains 475
It seems to drop the .00. Is there a way to get the .00 to display without having to format the column after opening because the file goes straight through for further processing without it being opened?

Did you check the sprintf function?

Could I use the format as:
string result(15)
result = sprintf$("%a",tfgld106.amnt)

Do you open the csv file in Excel or as a text file? I think as a text file it will have whatever you wrote to it. Once you open it in excel it will strip off leading zeros, remove decimal points etc.

The user opens the file in Excel.

Hi,

They can then select the column and do a Ctrl+Shift+1 to add those 00. Also check if this thread. (http://www.baanboard.com/baanboard/showthread.php?t=64653) can help