• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Get decimal number with zeros

madocar

Member
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
 
Back
Top