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.
The values are the same in the cell and the formula bar. There is a difference in formatting. You can control the formatting of the cell, but will not have the same degree of formatting with the formula bar. The role of the formula bar is to show you the true contents of the cell, and the sheet itself is where we are concerned with looks and formatting.
Not trying to be obtuse, but I’m not seeing the problem here. Is there a task that is failing because of the difference in formatting?
Not coming off as obtuse, and i'll try my best to explain the issue but I do understand what you are saying.
The goal is I am doing an import of clients into our system for an integration so the info syncs correctly and we sync using the Client ID, which is case sensitive.
When I imported the data into my system, i want to import the Client ID - 1105416.000 (what i see in the cell). When using my importer tool to match the corresponding fields in our system with the field in the spreadsheet, the value example the importer tool is showing is Client ID - 1105416, which is incorrect. I ran a small sample to test and it imported as 1105416, but it has to be 1105416.000
Gotcha. You will need to import and format as text, not numbers. Depending on your importing tool and your destination file you may need to first dump the data into another sheet prior, clean up formatting, then paste values into the destination.
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!