=C6& ""&A6 keep formating

[jamesa2487]

Hi

Hopefully something really simple

You will see below that the formula in B is =C6& ""&A6 the only problem is that the 35.60% loses it formatting of %, how can i keep this in coloum B?


A B C
35.60% Cost -0.355983302411874 Cost -


Thanks

[shukla.ankur281190]

Try

Please Login or Register  to view this content.

[sweep]

Hi,

How about something like

=TEXT(C6,"##.##%")&" "&A6

[leelnich]

Or:
=C6&" "&TEXT(A6,"0.00%")

[sweep]

Or:
=C6&" "&TEXT(A6,"0.00%")

Probably the better solution as this will retain the 2dp format whereas the ##.## won't.