How to wrap cells that have numbers

[Adrian20XX]

Hi,

I have a cell that has this number format: "VERY VERY VERY VERY LARGE TEXT" 0,0000000000%.
I need the text to be there to understand what the cell means, and I need it to be a number because other cells use this cell's value to perform calculations.

If I let the column fit to the full size with the number in it, it displays:

VERY VERY VERY VERY LARGE TEXT 3,5000000000%

If I put the the whole text (TEXT, not number) in a cell with a smaller column width and select for the cell alignment: Text Control, Wrap text to be checked, it displays:

VERY VERY VERY VERY LARGE
TEXT 3,5000000000%

However if I select wrap text in the cell that has the number and the number format, wrap text does not work (what might make perfect sense cause now it's actually a number), and it displays:

####################

Is there any way to get it displayed as I want, and also having there a number and not a text?
TIA & Regards ...

[JBeaucaire]

I know this isn't what you want, but wrapping REAL numbers with text is not a standard thing, and this may serve you in the same capacity.

If the issue is that you want some text in the cell describing what is going on in the cell, then use this trick to make an IN CELL comment. This is text that is IN the cell, visible on the Formula Bar, but does not display on the sheet so the number appears cleanly.

=350000000000000%+N("This is a very very very very very very long line of text")
...or
=N("This is a very very very very very very long line of text")+350000000000000%

I've use this frequently to leave reminders to myself what cells are doing, I don't like using the Comment feature, so this works for me.

[shg]

I don't think so.

Put the text in an adjacent cell.

[Adrian20XX]

Thanks for the answers.

I didn't explained properly the full problem, so here it goes.
First, this is a column for displaying all the concepts that this current rows cells are (I have later multiple columns with different cases of "real values").
And second, I have multiple cells like this in the "Concepts" column".

So, JBeaucaire proposition does not allow me to look at all the text at the same time, so it's not good.

shg proposition fits better to the idea of what I wanted to do, so I added an extra column that I'd call "Concept as Text", that has this formula:
=IF(ISTEXT(B1);B1;"VERY VERY VERY VERY LARGE TEXT " & TEXT(B1;" 0,0000000000%")

So, the "Concept as Text" column can wrap, and looks now like this:

Concept as TEXT
CONCEPT A
CONCEPT B
CONCEPT C
VERY VERY VERY VERY LARGE
TEXT 3,5000000000%
VERY VERY VERY VERY LARGE
TEXT 7,0000000000%
VERY VERY VERY VERY LARGE
TEXT 10,5000000000%

Not as perfect as I wanted, but it's ok at the "cost" of this extra column (what I don't like about it is not the extra column, but that the spreadsheet get additional complication to be read).

If anyone can come with a better idea, it's more than welcomed :-)