Hi,

Frank helped me with the second part of my problem but I have now
realised that the two formatting lines in the macro below override one
another rather than work in sucession.

Range("aa12").NumberFormat = _
Range("d10").NumberFormat & 0

(Sets the number format in DP in cell aa12 to d10 plus one more DP).

'Range("AA12").Select
'Selection.NumberFormat = "+#0.##0;-#0.##0"

(Sets either a prefix of + for pos numbers or - for neg numbers).

When I run the macro it sets the DP correctly at one extra than the DP
in d10, but then goes to a general format losing the DP but with the
prefixes.

I need them to both work together.

Is there another way to achieve this?

Thanks for help in advance,

Aaron.