The "--" (double unary minus) will coerce the text to numbers/times, so
if you included them, SUBSTITUTE() returning Text is not the problem.




In article ,
"Mick Stohr" wrote:

Must have done something wrong. get error message. The subsititute command
seems to give text back so it can't be summed. Dont understand the arrray
part. Would prefer using the period since its easier (so i am
lazy-efficient). Would you elaborate?