I have a column of cells that contain a single text character (A-Z). Some of these entries have a special significance and I want to identify them with an asterisk (eg: A*). However formulas in many other cells reference cells in this column and just typing in an asterisk causes these formulas to fail. I thought I would be able to create a custom number format for the cells General"*" to give me A* (for example) but apparently this only works on numbers (12345 in a cell does become 12345* when formatted to General"*"). I guess this makes sense since it is titled Format Numbers. Is there any way to do this with text or will I have to go through all the formulas on my sheet and alter them to allow for there possibly being an asterisk typed in the cell?