How do I display Text (Rent), but have a hidden value ($550)?
N Niek Otten Jan 4, 2006 #2 Format>Cells>Number tab, Custom In the Type box, enter "Rent" (including the quotes)
