Changing the currency settings at one workstation does not change it for everyone on the database. Just make sure you set it back to the default when you're done. Otherwise if you are the last one to disconnect, your currency setting will be saved as the default.
Karen -----Original Message----- From: Dan Goldberg <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Thu, Oct 10, 2013 9:21 am Subject: [RBASE-L] - formatting data when using gateway to export Our bank wants the currency field in a csv to be: 12345.00 No commas or dollar signs. Also, cents must always be there as .00 even if there are none. I tried using real which takes care of the commas and dollar signs but I need to always have the cents. I cannot change the settings as that will change everyone's settings. I am thinking there is a way to format the text when I do the gateway export command.. TIA Dan Goldberg
