Thanks for the solutions, but the problem is I am creating flat spool file and I need the format for example from the left most start position like below:
0029025.00

Now if I use to_char function then it leaves 1 space from the left
0029025.00
And for some reason we can not change the sqlldr control file, we have to follow the bank standard provided format.

Please help to resolve this issue.
* You may not see one space blank left in this page, please run emp query to see what I am trying to explain.

Thanks in advance,

aph.