Is it possible to have an Excel cell display a number (unique to each cell) when no data is entered?

Im unsure if this is possible. I need certain Excel Cells to display a number (unique to each cell) when I haven't entered any data in the cell. Its used to assign sites on a 'map/list' and I want them to have a number when no one has been assigned the site.