The currency setting is @$< space >formatting...
Try
? trans(12345.56,'@$ 9,999,999.99')
to get your comma etc.
Mike
>Yes now that you mention it. It looks like a bug doesn't it?
>
>Anyone have any suggestions regarding the set separator setting not working with the leading @ sign.
>
>Thanks
>
>>>>How do I format a currency with something other than a dollar sign. I have tried setting the Windows settings to another currency and then setting VFP to use the windows settings but when I
>>>>? trans(12,345.56,'$$,$$$.99')
>>>>
>>>>
>>>>it is still $
>>>>
>>>>Thanks
>>>
>>>Answered my own question!
>>>? trans(12345.56,'@$$,$$$.99')
>>>
>>>
>>>the @ sign forces the alternate currency symbols.
>>
>>
>>Did you notice you lost your comma? Seems to be a result of using the @.
Regards
Mike