No. That doesn't work. It won't take 16 digit numbers without either changing
them to a formula or altering the last digit to a 0.

"Dave O" wrote:

Format the cells as Text.