How to prevent excel from changing my number values

[Kyletok]

I don't understand why it does that,

I have a userform which inputs invoices into a table

when I try to enter the invoice number (for example, 312650370010022819) it enters a changed number to the cell! (changes the example to 312650370010022000)

Then I also have a feature in the initilize event of the form to pull the last value when opened again, and it pulls it as "3.12650370010022E+17"!!

how can I prevent that from happening?

is there a way to specify for this line :

[Invoices].Rows(x).Columns(c1) = InvoiceNumber.Value

to enter the value as string?

 

[Kenneth Hobson]

https://support.microsoft.com/en-us/help/2643223/long-numbers-are-displayed-incorrectly-in-excel