Negativ Amount to String convert

[Former Member]

hi all

how can i convert a negative amount(example 94.34-) to string. It should after convert like that -94.34.

i want give the amount out in excel, with DOI......

I hope you know, what i mean.....

thx very much

kostonstyle

[Former Member]

Concatenate '-' and absolute value of the negative value.

Thanks

Rakesh

[Former Member]

how can i catch up the dump CONVT_NO_NUMBER?

[brad_bohn]

There's no need to use ABS and check the value to determine whether or not to concantenate. One option is to write the value to your character like field then use CLOI_PUT_SIGN_IN_FRONT to move the sign position - it works whether the value is positive or negative...