@Cutter Yes they all can be formatted as text. I prefer text. But the preformat is being changed to scentific when the paste occurs. I am copying data in a spreadsheet forma from an email and pasting it directly into my excel spreadsheet.