Hi All,

For report TFACP 242111000, I have add in new field BALANCE.HC, it run smoothly,
When converted text to column(convert to excel), the 3 columns display -ve sign in front of figure, but not for this field the -ve sign display at the back.
Please refer attachment.

Is there any way to rectify this issue.

Thank You.

Hi,

While doing text to column, when you hit "Next" two times, you have "Advanced" option. So, select the columns, click on Advanced, and then select "Trailing minus for negative numbers" and Finish. Check if this helps. Else, you will need to do it through report layout by setting the format.

Hi Bhushan,

Already select on "Trailing minus for negative numbers", but produce the same result.

In the report layout, I put the format as ZZZZZZZZZZZZ9V.99, yes, the output display the -ve sign in front of the figure, but the thousand sign(comma) disappeared.
Any print format should I use to fulfill both requirement.

TQSM.

Hi All,

I use this format : ZZZ,ZZZ,ZZZ,ZZ9V.99
I think the issue resolved.

TQ.

Hi,

You can check if this works for you ->

ZZZTZZZTZZ9VD99

Instead of hardcoding the commas, its better to use a "T" symbol.

Hi Bhushan,

Yes, it's works.

TQVM.