Good Day I have tried many ways to use autosum from all over. A company use 10 zero's infront of the number and when I want to use autosum it give a 0 as answer. Any formulas that I can use, I used a Macro I found on Google and also this one =SUBSTITUTE(H1,CHAR(160),"")+0 but even that did not do the job for long. I really need something to use on a permanent basis to add up figures please. Pete