I have some sheets with various number formats, I want to be able to
increase (and sometimes decrease) all of them by one or two decimal places.
So...

"0.0%" will become "0.00%"
"#,##0_);[Red](#,##0)" will become "#,##0.0_);[Red](#,##0.0)"
"£#,##0" will become "£#,##0.0"
etc...

Can I do this?

Is there a 'Number of DP' property of a cell?

Can I simply find out the number of DP there is in a format?

Many thanks

M