Skip to Content
0
Former Member
May 24, 2008 at 06:29 AM

Number Format

21 Views

Hi

w_rwbtr is a character field.

Suppose the value of w_rwbtr is 1234567

I want to display it in the format

1,234,567.00

I was asked to try the below solution..

declare w_rwbtr1 as type P decimals 2.

move w_rwbtr to w_rwbtr 1.

again write ...

write w_rwbtr 1 to w_rwbtr.

It works but i do not get the comma separators.

It simply writes 1234567.00

but I want the comma separators as well. like

1,234,567.00