Cell: Data from Pivot + Text

[Yohnson]

Hello Friends,

How can I add some text to my Data in a cell?

The cell contains a number from another table atm, format: ='Business Line (3)'!I5

Is it possible to add a "mio €" to the value?


Thank you very much for the help!

[Sam Capricci]

yes, like ="mio €"&'Business Line (3)'!I5

[Yohnson]

I tried that approach, but I am getting an Error Message: "The formula is missing an area reference or a defined name"

[Sam Capricci]

any chance of uploading a sample workbook per the yellow banner's instructions at the top of the post?

[Yohnson]

Not sure how I can make a Sample Workbook out of it.

It works when I try the formula on a basic Sheet with no references to Input from other Sheets etc.
So I think it might be a problem based on the Data it gets or the cross-reference (Worksheet 1 has Data from Pivot, Worksheet 2 takes Data from Worksheet 1 etc.)


Edit: I think the problem might be related to the number being a part of a Chart or graphic?

[JeteMc]

Try using custom formatting.
Select the cell that contains the ='Business Line (3)'!I5 formula
Press Ctrl + 1
Select Custom
In the Type window put: "mio €" 0
Select OK
Let us know if you have any questions.