[SOLVED] How parse out characters from long string?

[Chet]

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

[Chip Pearson]

Use the Format function to get the correct numeric string, then
use your Mid command on that. E.g.,

Debug.Print Mid(Format(Range("A1"), "0"), 1, 4)



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Chet" <[email protected]> wrote in message
news:[email protected]...
> 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
>

[Chet]

Thanks very much !.... Chet