Excel is replaceing last 2 digits with 0

[Sicuu]

Hello,

I have a problem with my worksheet in excel. I'm trying to get data from a website, but the last 2 digits of the numbers with 18 digits are replaced with 0.

I tried to format cells to text, number, general with the value 0. it's not working. I've formated them before and after getting data from web. I have no clue of what should i do next.

Please help me.

Thank you.

 

[Joe4]

Welcome to the Board!

The issue is that with numbers, Excel can only track 15 significant digits. So it needs to be brought in as Text. But you have to do that BEFORE bringing it into Excel (once it is already in there, you have already lost the last two digits).

How exactly do you get the data from the website to Excel?

 

[barry houdini]

Excel doesn't recognise more than 15 significant digits, so you need your data to be formatted as text, how are you importing? If you can do that with "text to columns" there's an option to specify the column format, so you can make that "text"