wow, too much for brain to take in from text, how about a screnshot or two, or sample file? hehehe
What version of FileMaker are you using? "use notation" sounds like a reference to an older version here and it can make a big difference in our answer if you are using and older version.
The quotes in your csv file are epected behavior and shouldn't be a problem if you then intend to import from a csv file into another application.
If you enter browse mode and click/tab into this field, do you see that dollar sign?
One way to limit the decimal points for your export is to use the round function to round to the desired number of decimal places. This can be done by defining a calculation field that rounds the number and you then export the calculation field or you can use replace field contents with the calculation option to update the numbers in your field to be the rounded values. (make a back up copy of your file before you try this...)
"I have precision set to 2 on the field calcualtions..."
Could you write here that calculation ?
Is it a calculation field or a number field with the option of auto-enter a calculation ?
I am using FM Pro 10.
The filed [s_Total Bill] that I am displaying and exporting is a summary field of a calcualtion field [Total Charge] for which the calculation is set as follows:
SetPrecision ( c_Charge + c_Charge Tax ; 2 )
Number format on the [Total Charge] field on the layout is set up to display 2 decimal digits and no dolar sign. In the browse mode the field displays 2 decimal digits and no $ sign. If I click in the field I do not get $ sign but I do get 3 decimal digits.
I in the script to export I use the Export Records [No dialog; "upload.csv"; Windows (ANSI)]
where there is the option to Specify export order and in there I have Apply Current layout's data formating to exported data checked. I just don't get it where the $ sign comes from.
I think you want Round ( c_Charge + c_Charge Tax ; 2 )
SetPrecision has a minimum precision of 16 decimal places so your expression defaults to 16 places.
I don't see where the $ is coming from either.
What do you get if you import this data back into a FileMaker file and specify a text field to receive the imported number?
If I use Round function it rounds 63.728 to 63.72. I double checked. I did not know that about SetPrevcision. I will get back to this tomorow. Thank you Phil!
The round function should round that value to 63.73.