R
Ron
I have a database that exports a table to a fixed width
file. I have a problem with exporting fields that are
currency. The final file cannot have a $ in it. If I
format the field to currency with no dollar sign showing,
the $ sign still shows up in the text file. If I change
the field to a number with two decimal places, it drops
the cents in the field. Does anyone know how to fix this?
file. I have a problem with exporting fields that are
currency. The final file cannot have a $ in it. If I
format the field to currency with no dollar sign showing,
the $ sign still shows up in the text file. If I change
the field to a number with two decimal places, it drops
the cents in the field. Does anyone know how to fix this?