Index Match function cuts off zeros
Hello all,
I am pulling a cell value from a different grid with an Index Match function. The cell value is "89.09740".
The value can be pulled succesfully, however, the number is displayed without the zero at the end: "89.0974".
Is there anything I can add to the below formula that would make sure no zero is cut off at the end of the number?
Here is the current formula:
=INDEX({ACC operations tracker all columns base sh Range 1}, MATCH($[Row ID]@row, {ACC operations tracker all columns base sh Range 2}, 0), MATCH([Item Number]$1, {ACC operations tracker all columns base sh Range 3}, 0))
Thanks in advance,
Dennis
Answers

Hey Dennis, although there is a 0  those numbers are the same so It shouldn't matter. However is you want to increase the amount of decimals you see you can edit it like this. (the button to the right is increase decimal and you can add as many 0's to the end as you like).
You can perform this action for the entire column as well.

Hi Brucey,
that was it! :D Thanks for the quick fix :)
Have a great day,
Dennis
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.7K Get Help
 406 Global Discussions
 218 Industry Talk
 456 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!