Hi all,

I'm trying to figure out a way to dynamically set the number of decimal places for a cell based on the number in a given series that has the greatest number of decimals. For example if I have:

100
125.78964
120.22
133.768
178.9

the result I'm trying to get is:

100.00000
125.78964
120.22000
133.76800
178.90000

Because one of the numbers goes to 5 places, all the numbers go to 5 places. If the number with the most decimals had only two places, all of the numbers would have two places.

I have a function that counts the number of decimal places in a given number, and then a simple MAX formula to get the largest number, but am stuck on how I can change the number of decimal places based on that result.

Any help would be appreciated!