Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert a value to a text incl apostrophe within the cell
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I convert text string into a cell reference | Excel Discussion (Misc queries) | |||
Aligning Wraped Text to the bottom of a cell | Excel Discussion (Misc queries) | |||
Cell Limitations ? Formatting and Size when exporting to Tab based Text file? | Excel Worksheet Functions | |||
Help inserting a Cell Value in a Text Cell | Excel Worksheet Functions | |||
Cell has an apostrophe and is text | Excel Discussion (Misc queries) |