>I suggest you write a little UDF, specifically because of the parentheses. I found in VFP 3 that VFP messed up columns of numbers that used parentheses. It would basically do this to a column on numbers:
[procedure snipped]
Kenneth, your little UDF works great...for left justified fields. Turns out I'd like to right justify the field of interest. Apparently, VFP is just as happy as a clam to squeeze white space out of the right side of character strings to be printed and right justified. And it does just that to the output of your UDF. (At least I assume that's what's happening since the ')' of the negative values aligns with the LSD of the positive values ... but only when I right justify).
Do you know of a character that prints as a space but is not interpreted as 'whitespace' by VFP.
"The Iron Fish: The water is cold...but the fish don't mind"
...Jay Jenks, boyhood chum