Using paste special of a formula (values) and replace all, spreadsheet
developed annoying habit of only working in the first cell of range and
remainder seem to be text only fields even though there was no format for
text on the cell.

Deleting cells and repasting did not help.

Pasting elsewhere did not help.

Workaround was redeveloping underlying formula for pasting which is
extremely time consuming. Have never seen this before.

Any suggestions ????