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?

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

=(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?

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

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 wrote in message
...
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?

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

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 he
www.oraxcel.com/projects/litlib

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

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

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" schreef in bericht
...
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 he
www.oraxcel.com/projects/litlib

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