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.
If I'm understanding right, you're worried about the number in your formula bar not matching the formatting of the highlighted cell. That's intended, the formula bar is showing the actual data. The cell is that data formatted how you request, not the other way around. Just like how if you formatted the cell to have red text it would not be red in your formula bar.
If you absolutely must have it have .000 at the end, convert your numbers to strings.
yeah it absolutely has to have the .000 because it will be using that to reference another database to sync based on that client id. How do I convert numbers to strings?
Unless the values on the other database are strings instead of numbers,
12345.000 == 12345will be true