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.
Someone else posted a formula to convert the existing numbers to strings, but you can also just put a backtick(') in front of each number (and add the .000 as needed)