P
Peter W Soady \(UK\)
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
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