| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Digits to the right of decimal point
Hello,
What forumla should I use to get the digits to the right side of the decimal? i.e. if the number is 94.203, then I want to get the "203". Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Digits to the right of decimal point
You can use the following MOD function to return the remainder after dividing
the value by 1. The example assumes that the value to be divided is in cell A1, change formula based upon your layout: =MOD(A1,1) -- Kevin Backmann "Tigerxxx" wrote: Hello, What forumla should I use to get the digits to the right side of the decimal? i.e. if the number is 94.203, then I want to get the "203". Thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Digits to the right of decimal point
Thank you Kevin!
"Kevin B" wrote: You can use the following MOD function to return the remainder after dividing the value by 1. The example assumes that the value to be divided is in cell A1, change formula based upon your layout: =MOD(A1,1) -- Kevin Backmann "Tigerxxx" wrote: Hello, What forumla should I use to get the digits to the right side of the decimal? i.e. if the number is 94.203, then I want to get the "203". Thank you |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Digits to the right of decimal point
On the other hand, if you always have 3 digits to the right of the decimal
you could use =RIGHT(A1,3). If there aren't fixed decimals, the following would work: =RIGHT(A1,LEN(A1)-(FIND(".",A1,1))) -- Kevin Backmann "Tigerxxx" wrote: Hello, What forumla should I use to get the digits to the right side of the decimal? i.e. if the number is 94.203, then I want to get the "203". Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extracting digits to the right of a decima point | Excel Worksheet Functions | |||
| extracting digits to the right of a decima point | Excel Worksheet Functions | |||
| Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
| FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
| Displaying only digits after the decimal point | Excel Worksheet Functions | |||
Linear Mode
