Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 queries: Display last cell, and compare two lists | Excel Worksheet Functions | |||
MS Excel 2000 Cell Capacity and Data Display | Excel Discussion (Misc queries) | |||
have cell display the word balance when a equals the same amount a | Excel Discussion (Misc queries) | |||
How do I set a cell to "Empty" so that it does not display in a ch | Charts and Charting in Excel | |||
Display actual contents of cell | Excel Discussion (Misc queries) |