ExcelBanter - Hidden Values

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Hidden Values (https://www.excelbanter.com/excel-worksheet-functions/63156-hidden-values.html)

Loonball81

Hidden Values

How do I display Text (Rent), but have a hidden value ($550)?

Niek Otten

Hidden Values

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)?

All times are GMT +1. The time now is 12:33 AM.