Am having problems parsing out characters from a long string I have
many rows of. The data looks like 215781507021 and the problem is that
the Excel keeps converting the data to the scientific notation format
(example 2.15782E+11) when I use the mid( ) function to take the
selected characters that I want. What am I doing wrong? I even tried
using the cstr() command to change the format to 'text' but I still
keep getting just the n-th characters from the scientific notation
version of the number.

Thanks,
Chet