I have a field with amounts in it. For example:
Debit Amount:
00000006223
00000004356
0000000432r
0000000845v
00000006226
0000000198s
0000001638w
0000000911r
00000013667
0000000113q
00000001508
However, when the ‘Debit Amount’ has a letter as the last character,i need to replace the letter with a zero and make the whole number negative.
Anybody have any ideas?
I tried using the replace fuction but then would have to use it for every letter and then I dont know how to make it a negative.
Debit Amount:
00000006223
00000004356
0000000432r
0000000845v
00000006226
0000000198s
0000001638w
0000000911r
00000013667
0000000113q
00000001508
However, when the ‘Debit Amount’ has a letter as the last character,i need to replace the letter with a zero and make the whole number negative.
Anybody have any ideas?
I tried using the replace fuction but then would have to use it for every letter and then I dont know how to make it a negative.