Numbers will correct many kinds of standard formatting when typed in, but the same data may remain in its original, varied form when pasted in or when you open a CSV (comma-separated value) file ...