
So, I'd like to pull the first three digits from a different column and place them in another column while turning any other digits in the original column into zeros in the next column.
This is what I mean:
[TABLE="width: 178"]
<colgroup><col><col></colgroup><tbody></tbody>[/TABLE]
[TABLE="width: 178"]
<tbody></tbody>[/TABLE]
[TABLE="width: 193"]
<colgroup><col><col><col></colgroup><tbody></tbody>[/TABLE]
[TABLE="width: 325"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Column A
[/TD]
[TD]Column B[/TD]
[TD]Column C[/TD]
[TD]Column D[/TD]
[/TR]
[TR]
[TD]$123,456.78
[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]$123,000.00
[/TD]
[/TR]
[TR]
[TD]$89,798.90
[/TD]
[TD] [/TD]
[TD][/TD]
[TD]$89,700.00
[/TD]
[/TR]
[TR]
[TD]$3,894.03
[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]$3,890.00
[/TD]
[/TR]
</tbody>[/TABLE]
I'm not sure this is even possible but I'm sure there's a way to get it to work that is way beyond me.