title: Problem with left_join or How to convert character (in scientific form) to character (to numeric form)?
body: <p>I want to join two DFs by couple of variables. All of variables have to remain <code>as.character</code>.
  However, one is converted to scientific notation.
  Question is, how do I transform <code>data2$ID_Value</code> to character to &quot;XX00000000&quot; form?
  Converting to numeric and joining works, but I have to play with characters.</p>
  <p>#this works</p>
  <pre><code>data1 &lt;- data1 %&gt;% mutate(ID_Value = as.double(ID_Value))
  data2 &lt;- data2 %&gt;% mutate(ID_Value = as.double(ID_Value))
  data.join &lt;- left_join(data2, data1, by = c(&quot;Coding&quot;, &quot;ID_Value&quot;, &quot;Year&quot;))
  </code></pre>
  <p>#How to join with type(ID_Value) = as.character?</p>
  <p>#Here is the data.</p>
  <pre><code>data1 &lt;-
  structure(list(Coding = c(&quot;PL01&quot;, &quot;PL01&quot;, &quot;PL02&quot;, &quot;PL03&quot;, &quot;PL03&quot;, 
  &quot;PL04&quot;, &quot;PL05&quot;, &quot;PL06&quot;, &quot;PL07&quot;, &quot;PL08&quot;, &quot;PL09&quot;, &quot;PL10&quot;, &quot;PL10&quot;, 
  &quot;PL11&quot;, &quot;PL13&quot;, &quot;PL13&quot;, &quot;PL14&quot;, &quot;PL16&quot;, &quot;PL17&quot;), ID_Value = structure(c(1L, 
  2L, 1L, 3L, 7L, 10L, 8L, 12L, 9L, 11L, 5L, 3L, 4L, 6L, 1L, 4L, 
  2L, 11L, 7L), .Label = c(&quot;1100000000&quot;, &quot;1140000000&quot;, &quot;2120000000&quot;, 
  &quot;2240000000&quot;, &quot;3060000000&quot;, &quot;3200000000&quot;, &quot;3260000000&quot;, &quot;4300000000&quot;, 
  &quot;4320000000&quot;, &quot;5020000000&quot;, &quot;6040000000&quot;, &quot;6220000000&quot;), class = &quot;factor&quot;), 
      Year = c(&quot;2010&quot;, &quot;2010&quot;, &quot;2010&quot;, &quot;2010&quot;, &quot;2010&quot;, &quot;2010&quot;, 
      &quot;2010&quot;, &quot;2010&quot;, &quot;2010&quot;, &quot;2010&quot;, &quot;2010&quot;, &quot;2010&quot;, &quot;2010&quot;, &quot;2010&quot;, 
      &quot;2010&quot;, &quot;2010&quot;, &quot;2010&quot;, &quot;2010&quot;, &quot;2010&quot;), `1814` = c(5787.88072428485, 
      27730.4960757182, 5787.88072428485, 8932.52590304165, 1977.15424781852, 
      22593.7415704718, 18845.7534728209, 10534.5762707541, 5722.88747773182, 
      6536.13205513642, 2706.63712073692, 8932.52590304165, 29410.372540196, 
      1774.21615143866, 5787.88072428485, 29410.372540196, 27730.4960757182, 
      6536.13205513642, 1977.15424781852)), row.names = c(NA, -19L
  ), class = c(&quot;tbl_df&quot;, &quot;tbl&quot;, &quot;data.frame&quot;))
  
  data2 &lt;- 
  structure(list(Coding = c(&quot;PL01&quot;, &quot;PL01&quot;, &quot;PL02&quot;, &quot;PL03&quot;, &quot;PL03&quot;, 
  &quot;PL04&quot;, &quot;PL05&quot;, &quot;PL06&quot;, &quot;PL07&quot;, &quot;PL08&quot;, &quot;PL09&quot;, &quot;PL10&quot;, &quot;PL10&quot;, 
  &quot;PL11&quot;, &quot;PL13&quot;, &quot;PL13&quot;, &quot;PL14&quot;, &quot;PL16&quot;, &quot;PL17&quot;), ID_Value = structure(c(2L, 
  1L, 2L, 3L, 6L, 10L, 9L, 12L, 8L, 11L, 5L, 3L, 4L, 7L, 2L, 4L, 
  1L, 11L, 6L), .Label = c(&quot;1.14e+09&quot;, &quot;1.1e+09&quot;, &quot;2.12e+09&quot;, &quot;2.24e+09&quot;, 
  &quot;3.06e+09&quot;, &quot;3.26e+09&quot;, &quot;3.2e+09&quot;, &quot;4.32e+09&quot;, &quot;4.3e+09&quot;, &quot;5.02e+09&quot;, 
  &quot;6.04e+09&quot;, &quot;6.22e+09&quot;), class = &quot;factor&quot;), Year = c(&quot;2010&quot;, 
  &quot;2010&quot;, &quot;2010&quot;, &quot;2010&quot;, &quot;2010&quot;, &quot;2010&quot;, &quot;2010&quot;, &quot;2010&quot;, &quot;2010&quot;, 
  &quot;2010&quot;, &quot;2010&quot;, &quot;2010&quot;, &quot;2010&quot;, &quot;2010&quot;, &quot;2010&quot;, &quot;2010&quot;, &quot;2010&quot;, 
  &quot;2010&quot;, &quot;2010&quot;)), row.names = c(NA, -19L), class = c(&quot;tbl_df&quot;, 
  &quot;tbl&quot;, &quot;data.frame&quot;))
  </code></pre>