I think someone will have to come up with a VBA macro to do it for you (I am not a VBA expert).. as I don't think there is a way in native Excel to determine which of the 2 formats you have and to change the CR to -ve.....