When you create a formula that refers to other cells, it will have the same number format as the first cell it refers to. ...