The # is displaying because the width of the the column is less than necessary to display the data:
or right click column label and select Column width.