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