Dear experts,
I need a workaround BW reporting and the use of pivot tables in Excel. BW
downloads e.g. material numbers incl an apostrophe e.g. '112233. However,
this apostrophe is only shown when you press F2, i.e. this is a text format.
From another excel file I have the material numbers as values e.g. 112233. I
need to convert this 112233 to '112233, but in a way so the apostrophe is
only shown when you press F2. I have tried several formulas e.g.
=concatenate, =text etc. and can easily get the '112233 with the apostrophe
shown, but not as "real" text.

Does really appreciate you help in this, thanks a 1000 times

Best
Jakob