Skip to Content
0
Former Member
Jan 10, 2007 at 11:38 AM

Need some help on formatting techniques used in excel sheets

19 Views

Hi All

I have to convert the data in the internal table to a certain format XXXXXX and need to perform mapping for the same.

I got stuck at a point were in i need to follow certain rules to achieve that format like

1. left justify character fields

2. right justify numeric values

3. right justify amount decimal point and 2 decimal places not to use commas and $ symbol.

4.Null values need to be blank.

Can anyone plz send me the code for the following rules as i have never worked on this kind of requirement.

Helpfull answers will be awarded.

plz help me...

thanks,

Message was edited by:

skk