madocar Member Jul 7, 2017 #1 Hello, is there any way how to extract decimal numbers with zeros? Example: Number: 1,6 =VALUE(MID(MOD(1,6;1);FIND(",";1,6)+1;2)) = 6 I want to get value 60 Is there any way how to get two decimal numbers please? Thanks for any help
Hello, is there any way how to extract decimal numbers with zeros? Example: Number: 1,6 =VALUE(MID(MOD(1,6;1);FIND(",";1,6)+1;2)) = 6 I want to get value 60 Is there any way how to get two decimal numbers please? Thanks for any help
Hui Excel Ninja Staff member Jul 7, 2017 #4 If you always have one decimal place =10*(1,6-INT(1,6))&0