Press ALT+F11 to enter the Visual Basic Editor. Insert | Module. Enter the following code which assumes that you want the invoice number in cell A1.
Range("A1").Value = Range("A1").Value + 1
Exit the VBE. Each time you open the saved workbook the number will increase by 1.