Excel

Hey folks,

I can't seem to understand this issue or how to fix it, hoping for some guidance.

I have a set of data, in column B, i want all the numbers to have 3 decimals places. Some naturally do in the data set but others don't so I formatted the column to be Numbers and add 3 decimal places.

This is fine at a glance but my issue is that is not the true value in the cell. In the specific cell it shows how I want it to show, but when i look at the formula bar, it is showing the value without the 3 decimal places and when i go to import, the system is also showing the value without the 3 decimal places.

I have tried copy and pasting the column, pasting values only or changing the format to text instead of numbers and nothing is working.

I am pulling my hair out trying to figure out where i am going wrong because it seems like such a simple task.