Adjust Decimal Places in a Macro

[Maxknell]

I'm trying to automate a task where I have a column of numbers with varying lengths and need to set the whole column to the same amount of decimal places as the longest number, and then add a trailing zero to every number.

Example
-7.56
0
-13.50
0.1546879

Would turn into
-7.56000000
0.00000000
-13.50000000
0.15468790

This, unfortunately, means I cant simply set the column to a specific decimal place format and forget about it because it's different every time.

I was trying to experiment with setting up some kind of formula array using MAX(LEN(range)) and then somehow taking that variable (+1) and using it to assign the decimal places somehow but I'm currently stumped.

Anyone have a solution for this problem?

[xladept]

Hi Maxnell,

Welcome to the Forum!

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic