Forum Discussion
karolina189
Apr 24, 2022Copper Contributor
Remove spaces in in list of numbers - numbers are not displayed correctly
I have to read an Excel file originating from a website into R-Studios (xml). There is a row with numbers where there is unnecessary space between some digits, like:
| 8350 8380 8384 8385 |
I wanted to remove the spaces, using STRG + H. Then the numbers are displayed such as:
| 8,35084E+15 |
I tried to replace them with the normal form, but then the numbers are displaced incorrectly with a 0 at the end. How do I adress this problem so that all numbers are shown as (example):
| 8350838083848385 |
1 Reply
- OliverScheurichGold Contributor