I have a column of
cells with values - 0.2%, 0.32%, 0.22, 0.5 etc.
The cells with % symbol are in '
Percentage, 2 decimal'
format while the plain numbers are in 'General' format i.e. column contains cells in either of these formats.
I need a macro where I can specify the column and it will select the cells with the % format,
convert it to 'General' and multiply the result by 100 eg. 0.2% converted to 'General' becomes 0.002. When multiplied by 100, result is 0.2 i.e. is displayed without the % symbol.
Many thanks for your help.