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