Re: OT: VBA Newbie Needs Help
by Norman Bunn <norman.bunn(at)craftedsolutions.com>
|
Date: |
Fri, 31 Jan 2003 17:22:20 -0500 |
To: |
JimMenees(at)aol.com, hwg-languages(at)hwg.org |
In-Reply-To: |
aol |
|
todo: View
Thread,
Original
|
|
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