In the financial industry, there are security #'s called "cusips". An example of one of these 9 digit cusips would be "912828e72"

Is there a way to format a cell, to get that cusip number to stay like that? (the "e" makes the excel cell think it's an exponential number)

Even using the custom formats, you get back: "9128280000000000etc..."
I want it to read "912828e72"

In addition, I can not use ' or " because that would require me to ge into each cell where one of these problems exist. (it's thousands of lines of data.)

I'd appreciate any help.
Thanks, rich Hartmann