How can I prevent a number that doesn't fit on a column to be shown as ####?

[GabrielaMontero]

Hi everyone,

I'm working on a Straight Table on QlikView 12.2 SR6, and

I need to prevent what happened on cells B5, C4 and C5 of the following example table.

What i need to achieve is what you can see on cells D4 and D5 (even if the number is partially shown):

When I set the column as text, the format of the number is lost, so it's no good.

Please help, thanks!

[GabrielaMontero]

This is the real view of the table, as you can see, the values are previously formatted (###.###) and shown as M$

[Wlad_Masi]

Hi GMontero

Have you tried to use the wrap cell text option as shown in the image below?

[Wlad_Masi]

Hi GMontero,

Have you tried to use Wrap Cell Text as shown in the image bellow?