Number Format

[Former Member]

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

[Former Member]

Hi,

Declare one field to currency type and then try.

Also check the decimal Notation in user settings. ie. goto su01 > enter usename > click on display > deflut tab> check the Decimal Notation...If its not the one you want just change it.

REWARD IF USEFUL

[geetha_k]

Hi,

u will give the amount data type as CURR

check once this okk.

[Former Member]

thanks