Good morning Sam T,
I included your script and tried it. It works for the cells above H46 meaning that if I put a (+) number it converts it to a (-) number but H46 (total remit) should also be a negative but it's not converting it to a (-) number. Maybe its the placing of the EXPITM (the first add in) that's the problem. I'll keep working on it though. If you have any suggestions, it would be greatly appreciated.

Thanks again