E
ETLahrs
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
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