Excel formats
The only thing I can think of is a CASE statement in VBA.........what are the
largest and smallest "TEXT numbers" you would expect to enconter?
Vaya con Dios,
Chuck, CABGx3
"KDore@AIC" wrote:
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
|