Hi I noticed a green mark at top and for some reason it stated that the cells were in text format, so highlighted them all and changed to number, then formatted them again to number no decimal and it worked.