Display a digit before or after the decimal point in another cell

I want to be able to display the number that is so many spaces to the left
and right of the decimal point. Example: 1234.56 How do I put the
second digit to the left of the decimal point (number 3) in a different cell
in Excel? How do I put the first digit to the right of the decimal point
(number 5) in a different cell in Excel? What function would I use?

=(MOD(A1,10^3)-MOD(A1,10^2))/(10^2) will get you the digit three to the left.
Adjust all three exponents up/down by one to move one digit left/right.

"Robert Monks" wrote:

> I want to be able to display the number that is so many spaces to the left
> and right of the decimal point. Example: 1234.56 How do I put the
> second digit to the left of the decimal point (number 3) in a different cell
> in Excel? How do I put the first digit to the right of the decimal point
> (number 5) in a different cell in Excel? What function would I use?

If number is in A1, the second digit to the left of the decimal is extracted
with =MOD(INT(A1/10),10)

If number is in A1, the first digit to the right of the decimal is extracted
with =INT(MOD(A1*10,10))
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Robert Monks" <Robert [email protected]> wrote in message
news:[email protected]...
>I want to be able to display the number that is so many spaces to the left
> and right of the decimal point. Example: 1234.56 How do I put the
> second digit to the left of the decimal point (number 3) in a different
> cell
> in Excel? How do I put the first digit to the right of the decimal point
> (number 5) in a different cell in Excel? What function would I use?

>I want to be able to display the number that is so many spaces to the left
> and right of the decimal point. Example: 1234.56 How do I put the
> second digit to the left of the decimal point (number 3) in a different
> cell
> in Excel? How do I put the first digit to the right of the decimal point
> (number 5) in a different cell in Excel? What function would I use?

I have created a set of additional worksheet functions in an addin called
litLIB. I am using the ToString and the ToInteger functions in my litLIB
addin and the MID Excel function together to display the third digit in your
number. I trust that printing the other numbers individually is easy to
achieve:

=ToInteger(MID(ToString(B3),3,1))

If you are interested in litLIB you can find it here:
www.oraxcel.com/projects/litlib

Gerrit-Jan Linker
Linker IT Software
www.oraxcel.com

This worked great. Thanks.

"bpeltzer" wrote:

> =(MOD(A1,10^3)-MOD(A1,10^2))/(10^2) will get you the digit three to the left.
> Adjust all three exponents up/down by one to move one digit left/right.
>
> "Robert Monks" wrote:
>
> > I want to be able to display the number that is so many spaces to the left
> > and right of the decimal point. Example: 1234.56 How do I put the
> > second digit to the left of the decimal point (number 3) in a different cell
> > in Excel? How do I put the first digit to the right of the decimal point
> > (number 5) in a different cell in Excel? What function would I use?

Bernard,

I am having difficulty adjusting the formula for the other digits. I have
been adjusting the "10" to "100" and to "1". What should I be doing?

Thanks,

Bob

"Bernard Liengme" wrote:

> If number is in A1, the second digit to the left of the decimal is extracted
> with =MOD(INT(A1/10),10)
>
> If number is in A1, the first digit to the right of the decimal is extracted
> with =INT(MOD(A1*10,10))
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "Robert Monks" <Robert [email protected]> wrote in message
> news:[email protected]...
> >I want to be able to display the number that is so many spaces to the left
> > and right of the decimal point. Example: 1234.56 How do I put the
> > second digit to the left of the decimal point (number 3) in a different
> > cell
> > in Excel? How do I put the first digit to the right of the decimal point
> > (number 5) in a different cell in Excel? What function would I use?
>
>
>

Good morning,

When I tried the formula I got the #NAME? reponse. EXCEL changed the
formula to:

=ToiNTEGER(MID(tOsTRING(B3),3,1))

Thanks,

Bob

"Linker IT Software" wrote:

> >I want to be able to display the number that is so many spaces to the left
> > and right of the decimal point. Example: 1234.56 How do I put the
> > second digit to the left of the decimal point (number 3) in a different
> > cell
> > in Excel? How do I put the first digit to the right of the decimal point
> > (number 5) in a different cell in Excel? What function would I use?
>
> I have created a set of additional worksheet functions in an addin called
> litLIB. I am using the ToString and the ToInteger functions in my litLIB
> addin and the MID Excel function together to display the third digit in your
> number. I trust that printing the other numbers individually is easy to
> achieve:
>
> =ToInteger(MID(ToString(B3),3,1))
>
> If you are interested in litLIB you can find it here:
> www.oraxcel.com/projects/litlib
>
> Gerrit-Jan Linker
> Linker IT Software
> www.oraxcel.com
>
>
>

Hi Robert,

You probably have not installed litLIB yet. You can get it from my site
www.oraxcel.com/projects/litlib.

litLIB will add the ToString and ToInteger functions among another 100 or so
other functions.

Hope this helps,

Gerrit-Jan Linker
Linker IT Software
www.oraxcel.com

"Robert Monks" <[email protected]> schreef in bericht
news:[email protected]...
> Good morning,
>
> When I tried the formula I got the #NAME? reponse. EXCEL changed the
> formula to:
>
> =ToiNTEGER(MID(tOsTRING(B3),3,1))
>
> Thanks,
>
> Bob
>
> "Linker IT Software" wrote:
>
>> >I want to be able to display the number that is so many spaces to the
>> >left
>> > and right of the decimal point. Example: 1234.56 How do I put
>> > the
>> > second digit to the left of the decimal point (number 3) in a different
>> > cell
>> > in Excel? How do I put the first digit to the right of the decimal
>> > point
>> > (number 5) in a different cell in Excel? What function would I use?
>>
>> I have created a set of additional worksheet functions in an addin called
>> litLIB. I am using the ToString and the ToInteger functions in my litLIB
>> addin and the MID Excel function together to display the third digit in
>> your
>> number. I trust that printing the other numbers individually is easy to
>> achieve:
>>
>> =ToInteger(MID(ToString(B3),3,1))
>>
>> If you are interested in litLIB you can find it here:
>> www.oraxcel.com/projects/litlib
>>
>> Gerrit-Jan Linker
>> Linker IT Software
>> www.oraxcel.com
>>
>>
>>