I am concatenating a series of strings (the majority of which have a decimal value greater than zero), but those where the string (the result of an equation elsewhere) results in an exact .zero answer do not contain the decimal point and following zero, which is spoiling the concatenation. I have tried precision as displayed, converting to value and even multiplying by 1.0001 to try to force the point zero but with no luck. I am unable to use the if function (because I would be looking for a definite point zero – which isnt there. any ideas?
