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
Thanks in advance for your advice,