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