How do I make a cell value invisible?

I am creating a workbook for HR that requires an end date for a calculation. My boss has asked that I do not have this information present in a hidden column. I know you can make the text white, however, I want a way to make sure the text is never seen and never edited. How should I go about this? I also know there is command of "alt +" some combo of numbers/characters that will create invisible text. Any help is highly appreciated.

Thanks!

What's the reason for not having it visible? And what's wrong with having it in a hidden column?

Hide the column and protect that part of the sheet against amending.

Or, put that column on a different sheet and hide it. You can use VBA to hide it without it being visible in the list of hidden sheets.

Many ways to do this, but which would be best all depends on the reason for needing it hidden in the first place.

BSB

in A2 =today()
it is unseen, cannot be edited
but it can be deleted

Originally Posted by tim201110

it is unseen, cannot be edited

Unless you unmerge the cells

Unmerged and see everything....

Unprotected and see everything....

Originally Posted by BadlySpelledBuoy

What's the reason for not having it visible? And what's wrong with having it in a hidden column?

Hide the column and protect that part of the sheet against amending.

Or, put that column on a different sheet and hide it. You can use VBA to hide it without it being visible in the list of hidden sheets.

Many ways to do this, but which would be best all depends on the reason for needing it hidden in the first place.

BSB

I am going to try this method. I would respond to everyone individually but I thank you all for the advice!