Hi,

The title doesn't explain this very well!

There is a column of cells set to number which requires input into each cell. Some will require an input of quantity and some will require an input of m2 etc. These cells are part of a calculation for price so the numbers entered will be part of a formula in another cell.

I would like to put 'm2' in some cells to indicate that this is the type of data that needs to be entered. Is it possible to enter this in the cell and have it stay there permanently regardless of numbers being entered into the cell?

Thanks,
Amy