How do I hide a cell value to be viewed by a password?

[_dave]

I have two cells (B5 and C5) that has a number value that I want to hide, but be visual by a password. And the password should show ***** as input.
How can I complete this task? BTW, this will only be needed once per spreadsheet.

Thanks ahead for any help.
Control Number.ods (12.7 KB)

[sokol92]

@_dave

How can I complete this task?

The standard mechanism is sheet protection (see attachment). The password for unprotecting sheet is 12345.
Please note that such protection does not prevent a qualified user from viewing hidden data.

Control Number 2.ods (9.1 KB)

[fpy]

you can use Format > Cells > User-defined then put ‘***’ as format code.

Otherwise discussed here

How can I use cells in Calc as password fields?

In LibreOffice Calc, how do I set a cell so that it shows asterisks instead of the actual text in the cell (and so asterisks also show in the function part)? I just want to hide some passwords (but still be able to access them via a Python module). Is this possible? My current workaround is to use a crazy font that practically no one would understand (however, this doesn’t hide it in the function-bar). I don’t suppose this would save in an .xls file if the functionality exists, but that would al…