Hi,

I'm using Excel 2003. I'm not very experienced. My spreadsheet has some columns that get averaged automatically. I want the users of the spreadsheet to be able to enter a dash ( the minus sign ) if there is no data for the cell. At the moment this causes excel to think that a minus number is coming. Is there any way of getting excel to just display the dash without doing anything to it ? ( They will never be entering negative values into the cell )

Many Thanks in advance.

Marcus