why are pound signs or hashtags displayed in spreadsheet cell(s)?

The most common reason for this is that the cell isn’t wide enough to display the full contents.

The quick, easy way to increase the width of the cell is to double click on the column line after the cell within the header row. It will increase not only that cell, but the entire column.