Hi all,
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:
<colgroup><col><col></colgroup><tbody></tbody>
<tbody></tbody>
<colgroup><col><col><col></colgroup><tbody></tbody>
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
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.
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:
<colgroup><col><col></colgroup><tbody></tbody>
<tbody></tbody>
<colgroup><col><col><col></colgroup><tbody></tbody>
Column A | Column B | Column C | Column D |
$123,456.78 | $123,000.00 | ||
$89,798.90 | $89,700.00 | ||
$3,894.03 | $3,890.00 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
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.