I am using a userform in which 1 of the textboxes contains a 16 digit account
number. When the user seaches for the information after entering it in, the
account number returns as 1.23456789...E+15. The cells in which it is stored
is formatted as number with 0 decimal places. Also, when the account number
is originally entered, it is entered as 16 digits.

How can I format the textbox to just show the number, no E+15, no commas, or
currency?

Thanks,
Ed