| You may need to set the cell formatting on the range once you've copied the formulas over. Excel can be funny like this sometimes as it constantly tries to do a "best guess" about the formatting of a cell when the contents change. It's a right pita for us developers! |