Hi

I have a small problem which I can partly solve but not fully. The scenario
is following:

I have columns formated as number with 2 decimal places however I need to
split these columns into whole number and decimal number but I need the
whole number to be 4 digits in length. Example

                                      New Columns
Original Col            Whole Num     Decimal Num
   0.12                       0000                12
 12.12                       0012                12
120.12                       0120                12

I am not interested in the decimal point but the columns must conform to the
above or the Oracle Application will reject the import

I have tried different ways using the IF and LEN but seem to be banging
against the brick wall. I would accept any way of doing this, Macro, VBA or
Function. Howecver if it is macro or VBA I will also require the knowledge
on how to attach  this to the worksheet

Any help would be greatly appreciated

Peter W S