I have an excel file that has one column for Product No (alphanumeric). I
have found that some of the cell are displaying Scientific Notation (e.g.
4.00000e+016) even when I specified the formatting to be text. The only way
I could get them to show as 40000001235 is to go to each cell and click on
the formula bar. Is there an easier way? I've tried =Value(abc123),
=abc123, copy and paste special/values...but none of these worked. To top it
off, the formula remains instead of showing the value: =abc123 instead of
4.0000e+016.