Excel messes up some dots (".") in a number
<p>I have a tab delimited file: <br>
<a href="https://i.stack.imgur.com/zeaN4.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zeaN4.png" alt="enter image description here"></a>
I created this file in R as a data.frame and wrote it to the above file using <code>write.table(dataFrame,"filepath",row.names=FALSE)</code>. However after I opened this in excel I got some <code>#####</code> in my excel file: <br>
<a href="https://i.stack.imgur.com/TLE2B.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TLE2B.png" alt="enter image description here"></a><br>
The only difference between the tab del file and the excel file is that in the excel file the <code>.</code> is omitted, but I don't have any idea how this is possible because most of the other numbers are just fine. Any suggestion to fix this problem is welcome.<br>
<strong>Update</strong><br>
I can fit the data in the column: <br>
<a href="https://i.stack.imgur.com/1LTCp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1LTCp.png" alt="enter image description here"></a><br>
However there should be a <code>.</code> after the 1</p>