Two things -
1. Trying to format a money amount showing 2 decimal places eg if I put in £36 it is showing as that where I want it to display as £36.00
2. I want to show negative amounts in a cell in red. Does anyone know how to do this. It seems as you can do an entire row or column but not a single cell.
If anyone can help it would be much appreciated
cheers
Sandra
1. Trying to format a money amount showing 2 decimal places eg if I put in £36 it is showing as that where I want it to display as £36.00
2. I want to show negative amounts in a cell in red. Does anyone know how to do this. It seems as you can do an entire row or column but not a single cell.
If anyone can help it would be much appreciated
cheers
Sandra
