HurricaneBob
New Member
I'm trying to create a macro that can read the format of the current cell, determine the number of decimal places, and then add one more but I want it do be dynamic:
For example, if the current format is #,##0 , it will change the format to #,##0.0, and if the current format is #,##0.000 it will change to #,##0.0000
The tricky part is that I want to maintain the current cell format, so it would work with number, currency, percent, etc.
Appreciate any help!
For example, if the current format is #,##0 , it will change the format to #,##0.0, and if the current format is #,##0.000 it will change to #,##0.0000
The tricky part is that I want to maintain the current cell format, so it would work with number, currency, percent, etc.
Appreciate any help!