Ignore this error
When I set formatting in a cell for "text" and paste a number, stop giving an error that the number is formatted as text. I know. You know why?
See if you can follow:
I set the formatting manually. I already know it's a number being displayed as text. If I set something manually, stop telling me it's set that way. Especially if there are already important contextual clues (like the number sticking to the right side of the cell or not truncating or adopting date format, etc) showing that it's formatted as text.
I hate having to manually declare the formatting and then dismiss the error that my formatting was changed. I hate the errors in general, but that's broad enough that it only deserves to be tacked on to this rant.
Actually, it would be amazingly handy if this were a sheet-level option that we could turn on and off for a particular sheet.