I made a scraper in an excel sheet with many importJASON functions that fetch numerical datas from various APIs. The problem is that the format isn't uniform and messes up my VBA calculations. It throws a lot of #REF ! #ERRORS ! etc The reason is that some datas come with decimal separators, thousands separators, with either commas or dots.
It would also be nice to be able to determine the number of decimals allowed;
How can i possibly uniformize the datas into files usable by excel?
See example below
14485.0 14531.00 14749,99999 14950,95733 14536,87 14975 14298,96
It would also be nice to be able to determine the number of decimals allowed;
How can i possibly uniformize the datas into files usable by excel?
See example below
14485.0 14531.00 14749,99999 14950,95733 14536,87 14975 14298,96