Hi,
When I copy and paste values out of our finance package I get this:
2143.93 Cr
752.00 Dr
Basically I want Excel to convert them to something it recognises so I can AutoSum them, maybe have another column next to it with the converted figures.
So it will look something like this:
2143.93 Cr to -2143.93
752.00 Dr to 752.00
When I copy and paste values out of our finance package I get this:
2143.93 Cr
752.00 Dr
Basically I want Excel to convert them to something it recognises so I can AutoSum them, maybe have another column next to it with the converted figures.
So it will look something like this:
2143.93 Cr to -2143.93
752.00 Dr to 752.00