Skip to Content
0
Former Member
Apr 14, 2010 at 10:23 PM

Decimal issue

36 Views

Hi Friends,

I have a issue wherein I need to prefix '.00' at the end of a number. Problem is that the '-' sign is also at the end and if I try to concatenate, it doesn't work.

Eg.

2000.00 (for positive nos it is appearing fne and showing .00 as decimal)

750-

11189.3-

Here instead of 750- it should be 750.00-

instead of 11189.3-, it should be 11189.30-

One solution is I change the settings , make the '-' sign prefix an dthen concatenate '.00'. However I dont want to do this. I want to make XXX.YY- appear.

Please suggest.

Rgds,

Raj