this post was submitted on 30 May 2025
7 points (100.0% liked)
Excel
199 readers
1 users here now
A community dedicated to any discussion about Excel. QnA, Discussion of other spreadsheet applications and ancillary programming/scripting are also welcome.
founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
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?
I think you may be misunderstanding what the numbers you're seeing in the formula bar are? Its the absolute value in the cell.
12345.000 = 12345. It doesnt matter that you can't see the three 0s in the formula bar, its the same number.
12345.100 = 12345.1 The missing 0s dont matter.
Excel is storing the absolute values and will show you the decimals in the formula bar when they exist in that cell. When you cross reference it with your database it will be correctif tha data there us also numeric.
The potential issue could be if you dont want values to have more than 3 decimal places because of rounding errors. In that case you would need to apply a formula to convert the numbers to be truly 3 decimal spaces.
For example 12345.001 is not exactly the same as 12345.0005 as its been rounded up. Excel would have the number with all decimal places (within limits) and that could mismatch the data in your database if its stored to 3 decimal place. Then you might want to convert your data so it properly rounds the numbers as new absolute values to work with.
Unless the values on the other database are strings instead of numbers,
12345.000 == 12345
will be trueSomeone 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)