Are you asking to just change the red font to a negative number (i.e. £4,084.22 to -£4,084.22)? If so, simply go to Format Cell> and adjust the custom formatting to remove [Red] and add a negative sign.