Quick Doubleclick to Expand

I have over a thousand rows in one column which contains 20 digit employee IDs. The cells were formatted as Number, so the formula result was in scientific notation. We need the expanded number, so I converted the formulas to values, and formatted the cells as Text. Now, to get the cells to display the full value I have to double click into each cell. Is there a quicker way to do this?

I suspect you have a bigger problem, since Excel will only display numbers to 15 significant digits and anything after that will have been converted to a 0.

Nothing to be done about that now; going forward the field will be a text field, so we shouldn't have any problems then. But I'm still faced with how to convert the Scientific Notation cells to text value displays.

If they are formatted as Number, not General, they shouldn't be displaying in scientific notation.

They may have been as General, not number. Either way they're formatted as Text now, and showing in scientific notation.

To correct that, you can either code a simple loop, or use a formula like =TEXT(A2,"0") in another column and then copy/paste special - values over your old data.

So simple, and I use the =TEXT(A2,"0") for a host of other situations, but I couldn't see it for this. Brainblock. Thanks for pointing the way.