FormatCellsNumber tab, Custom
In the Type box, enter "Rent" (including the quotes)

--
Kind regards,

Niek Otten

"Loonball81" wrote in message
...
How do I display Text (Rent), but have a hidden value ($550)?