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.
Yeah i think the format of the sheet I was using was out of whack based on all my attempts at correcting it, I was able to paste into a brand new sheet and got the results I needed using another users suggestion of =TEXT(B2, "0.000") which was a success! Thanks for the guidance!