How to stop Long numbers from auto rounding...

I am working on an inventory issue, we use a bar code scanner to read in inventory, and when we move inventory.
One of our inventory items has a number that is 20-numerical characters long, Excel seems to convert the last 5 characters to zeros (0).
Does anyone have a fix, or work around?

An Example number would be: 89148000000286153971
Excel changes the number to: 89148000000286100000

Kind regards,

One way to is format the cells as text, another way is to add a ' in front of the values, saving them as text.

Cheers

Thank you. Formating as Text worked.
Next question - as these numbers are so long, do you have a recommendation on how to break them up with dashes.
I had originally formated the cells with Custom #####-######-#####-#### (we tend to use the last four numbers a lot, but need to be able to see the whole number.)

In that case you would need to format the text value directly for Excel not to round the number. Personally, I would use the whole number as is or perhaps use VBA to get the formatted barcode from the value saved as text (see below).

Function FormatBarCode(rng As Range) As String

    If rng.Cells.Count > 1 Then Exit Function
    
    FormatBarCode = Format(rng.Value, "#####-######-#####-####")
    
End Function

and also,

Function BarCodeFromFormat(rng As Range) As String

    If rng.Cells.Count > 1 Then Exit Function
    
    BarCodeFromFormat = Replace(rng.Value, "-", "")
    
End Function

Oh, very nice.

Thank you very much.