Google Spreadsheet content not displaying properly

  • 1
  • Problem
  • Updated 3 years ago
  • Solved
We have a Google spreadsheet listing a building tenants with their corresponding suite numbers.  In the column with the suite numbers, any suite that begins with a letter (ie: PH5) will not display in the preview or the actual presentation.  The field remains blank. 

If the "PH5" in the adjacent column, it shows up fine. 

Any ideas would be appreciated.

Photo of sedo enr

sedo enr

  • 140 Points 100 badge 2x thumb

Posted 4 years ago

  • 1
Photo of Blake Freeman

Blake Freeman, Official Rep

  • 36,116 Points 20k badge 2x thumb
Sedo,

This could have something to do with formatting of the cells in the spreadsheet. Could you try selecting all cells and clearing formatting?
Photo of sedo enr

sedo enr

  • 140 Points 100 badge 2x thumb
I took your suggestion and cleared all formatting and the issue remains.  I will next try to create an entirely new spreadsheet to see if the issue persists.
Photo of Robb

Robb, Official Rep

  • 76,676 Points 50k badge 2x thumb
Sedo,

When you make the new sheet, make sure that you create a brand new sheet, instead of a copy of the original. That way you can be 100% certain that no formatting was copied over. Thanks!
Photo of sedo enr

sedo enr

  • 140 Points 100 badge 2x thumb
I created a brand new spreadsheet along with a brand new placeholder pointing to the new spreadsheet with same result.  Zero formatting in spreadsheet. 
Photo of Blake Freeman

Blake Freeman, Official Rep

  • 36,116 Points 20k badge 2x thumb
Sedo,

Please select all cells in the spreadsheet and disable text wrapping.
Photo of sedo enr

sedo enr

  • 140 Points 100 badge 2x thumb
I finally found it.  I had to format the column with mixed text/numbers as "plain text".  I had to highlight the column, then at the top of the format menu, choose "number" and then change it to "plain text".  Thank you all for your help.
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
Thank you sir! You saved my day and like a ton of nerve cells :)
Photo of sshank

sshank

  • 1,186 Points 1k badge 2x thumb
THIS DID THE TRICK! Thank you so much for posting this. It was so frustrating.