title: Split a float number at decimal point using Excel VBA
body: <p>I am trying to split a number at the decimal point and store the two parts in two strings. </p>
  
  <p>E.g. 12.345 to be stored as S1 = 12 and S2 = 345</p>
  
  <p>E.g. 12.3450 to be stored as S1 = 12 and S2 = 345</p>
  
  <p>Can someone guide me with excel VBA for this?</p>