title: Text and Number Format on Excel
body: <p><img src="https://i.stack.imgur.com/Yx8wN.jpg" alt="enter image description here"></p>
  
  <p>I have question that when I want to compare between a1= 1.3 b1= 3 and a2= 1.3 b2= 2  on excel for example       <code>=IF(a1&gt;a2,"Yes",IF(a1=a2,IF(b1&gt;b2,"Yes","No"),"no"))</code></p>
  
  <p>First time it's okay, but then I changed value from b1 =1  it changed to "no"  then I changed it back to b1= 3  it's still "no"   </p>
  
  <p>I think it concern on format in the cell.</p>
  
  <p>Another concern is if I use like 1.3.1 compare to 1.3.1.2    it doesn't have any problem, but when I use only 1.3 (one decimal point) it always have problem  </p>
  
  <p>It's hard to explain you should try to compare between x.x  and x.x.x also if you have a good another VBA code to compare version number</p>
  
  <p>It like  1 decimal point excel see as number, but  many decimal point excel see as text</p>
  
  <p>How do I fix this (I have try change to text format but it work 1 time after you change value in cell it's go back to error.)</p>
  
  <p>Due to my English is poor.    to make it clearer    <code>"How do i make x.x see as text so that i can compare with x.x.x :) "</code></p>