Originally posted by Jim Yingst:
Sigh. Read the documentation. "#######" does exactly what it says it will do. So does "#######.0" - I just overlooked your need for a leading zero in the ones position. So use "#######0.0". Test it for other numbers too, to verify it does what you want.
I appreciate your help. I guess my wording is not as exact as you expect. I need nothing but ""(blank or zero length string) if the number is 0(zero)... The pattern ###### is supposed to do that. I did read the
doc and that's where I got it from. My problem is, it's not doing what it says it will do. I tested it. It is not doing it. Maybe I should blame the jvm not the language.