| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting numbers on the right side of the decimal point
What formula can I use to get the numbers on the right side of the decimal?
i.e. for a number 6.25, the result of the formula should be 25. Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Getting numbers on the right side of the decimal point
If it is always 2 decimals
=MOD(A1,1)*100 -- Regards, Peo Sjoblom "Tigerxxx" wrote in message ... What formula can I use to get the numbers on the right side of the decimal? i.e. for a number 6.25, the result of the formula should be 25. Thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Getting numbers on the right side of the decimal point
If you always want the number of decimals as integers like if you have
0.12345 and you want 12345 =MOD(A1,1)*(1&REPT("0",LEN(MOD(A1,1))-2)) -- Regards, Peo Sjoblom "Peo Sjoblom" wrote in message ... If it is always 2 decimals =MOD(A1,1)*100 -- Regards, Peo Sjoblom "Tigerxxx" wrote in message ... What formula can I use to get the numbers on the right side of the decimal? i.e. for a number 6.25, the result of the formula should be 25. Thank you |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Getting numbers on the right side of the decimal point
=RIGHT(A1,LEN(A1)-FIND(".",A1))
It is now 'text', but will keep any preceding zeroes (i.e.: 3.057 = 057) and will avoid the bad rounding that otherwise might occur. -- John C "Tigerxxx" wrote: What formula can I use to get the numbers on the right side of the decimal? i.e. for a number 6.25, the result of the formula should be 25. Thank you |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Getting numbers on the right side of the decimal point
If none of the suggestions work for you, you may want to explain what you want
when the original number is: 6.5 Do you want 5, 50, 500, ... Tigerxxx wrote: What formula can I use to get the numbers on the right side of the decimal? i.e. for a number 6.25, the result of the formula should be 25. Thank you -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Getting numbers on the right side of the decimal point
Thank you All!
Your solutions helped me! "Dave Peterson" wrote: If none of the suggestions work for you, you may want to explain what you want when the original number is: 6.5 Do you want 5, 50, 500, ... Tigerxxx wrote: What formula can I use to get the numbers on the right side of the decimal? i.e. for a number 6.25, the result of the formula should be 25. Thank you -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| aligning by decimal point - negative and positive numbers | Excel Discussion (Misc queries) | |||
| when I type numbers in a cell it changes it to a decimal point | Excel Discussion (Misc queries) | |||
| ALL NUMBERS I TYPE HAVE DECIMAL POINT | Excel Discussion (Misc queries) | |||
| Cut &paste clears numbers after the decimal point | Excel Worksheet Functions | |||
| Numbers after decimal point excel to word mail merge | Excel Worksheet Functions | |||
Linear Mode
