I have a cell D2, that has A1&B1 in it. Problem is, I want the format
from cell A1 to translate over also. IE decimal placing to 1dp and in
another case superscript to translate over also.

I have tried custom number format of #,0 and #.0 to no avail.

Cell D2 displays 7000g

A1=7000.0
B1=g

Thanks in advance for your advice,

Slash.