& function cell format translation.

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.

You can't using custom text format since when you concatenate A1 and B1 it
becomes text, you can use this
which is not formatting but text

=TEXT(A1,"0.0")&" "&B1

having said that is there a reason you cannot use a custom format like

0.0" g"

or do you have multiple values that need to be concatenated

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




<[email protected]> wrote in message
news:[email protected]...
>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.
>

Thanks for that, it has solved my problem. How do I get the superscript
to translate through to the cell also?

EG

A1=10oC
A2=+/- 1oC
A3=A1&A2

A3 Displays 100C+/-10C but I want to keep the superscript for the "o"

Thanks,

Slash.

Excel doesn't support that kind of formatting with formulas. If you convert it
to a value, then you can do the formatting, though.

[email protected] wrote:
>
> Thanks for that, it has solved my problem. How do I get the superscript
> to translate through to the cell also?
>
> EG
>
> A1=10oC
> A2=+/- 1oC
> A3=A1&A2
>
> A3 Displays 100C+/-10C but I want to keep the superscript for the "o"
>
> Thanks,
>
> Slash.

--

Dave Peterson

Excel doesn't support that kind of formatting with formulas. If you convert it
to a value, then you can do the formatting, though.

[email protected] wrote:
>
> Thanks for that, it has solved my problem. How do I get the superscript
> to translate through to the cell also?
>
> EG
>
> A1=10oC
> A2=+/- 1oC
> A3=A1&A2
>
> A3 Displays 100C+/-10C but I want to keep the superscript for the "o"
>
> Thanks,
>
> Slash.

--

Dave Peterson