Problem:
changing numeric values into text vales then adding a space into the text
cell, to take the place of the"," to denote thousands, move the "$" to the
end and change the "." to a comma, ex: $1,896,230.00 once changed to a text
value becomes "1896230.00", result I require is "1 896 230,00 $"

A number of Financial values across multiple spreadsheets require this type
of formatting. If this can be done as a macro or formula, that would be most
helpful.
--
Keith Dore