Character Field as Number, Need commas?

I move a quantity to a character field for a form display output. I left justify the character by shift character field left deleting leading spaces. This way it formats perfectly in the column on my report/form.

Is there any easy syntaxfunction module, etc., that will take char field 1000.0 and put inn a comma 1,000.0?

I don't want the value to shift back to the right (right-justify).

Thank-You

Edited by: TMM on Jan 30, 2009 11:30 AM