Preformat the cells your are pasting the formula into as General. They may be Text now.