Re: OT: VBA Newbie Needs Help

Jim,

That's a start, but I need to handle all numbers regardless of size.

IOW, what happens when instead of:

$20820.20$20131.28128

I get:

$9543.22$694.334

which should parse as:

$9543.22 $694.33 4

Norman

At 05:08 PM 1/31/2003, JimMenees(at)aol.com wrote:
>Here is how excel does it... using the excel built-in functions:
>Assume the number is in cell A1;
>For the left 9-digit number the formula is:
>=LEFT(A1,9)
>
>For the middle number the formula is:
>=MID(A1,10,9)
>
>For the last 3 digits the formula is:
>=RIGHT(A1,3)
>
>Hope that helps!
>~Jim

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA