Originally Posted by
RichHartmann
How do I format a cell to produce text, rather then the Exponential number for the following value:
912828e72
(Why? In the financial industry, there are security #'s called "cusips". An example of one of these 9 digit cusips would be "912828e72". I need to get that cusip number to stay in text format? (the "e" makes the excel cell think it's an exponential number)
Even using the custom formats like 000000000, or #########, you get back: "9128280000000000etc..."
I want it to read: 912828e72
In addition, This data is copied from notepad, and pasted into excel. Pasting as "text" still doesn't work. It also prohibits the use of lead apostrophe's and Quotes. (so I can't use '912828e72, because there are thousands of lines of data.)
I'd appreciate any help.
Thanks, rich Hartmann
Bookmarks