I have two identical spreadsheets where cells behave differently even though they are identically formatted. Each contain the same formula where the result is $0. In one the value '-$0.00' appears whilst in the other '$ -' appears. In the case of the former the resultis not recognised as zero...