Can I display leading 0's in google spreadsheet?

  • 1
  • Problem
  • Updated 3 years ago
  • Acknowledged
I have a couple leading zeros in my Google spreadsheet that I use with a presentation but when it displays the data, the leading zero doesn't show up. Is there anyway to fix this?
Photo of Geoff Kruse

Geoff Kruse

  • 250 Points 250 badge 2x thumb

Posted 4 years ago

  • 1
Photo of Alex Kolenoff

Alex Kolenoff

  • 3,506 Points 3k badge 2x thumb
Geoff, when I do this with a number (ie 0.6) it shows 0.6 in Preview as it is entered in the spreadsheet.  It does this whether I have the cell formatted as number or text.  Do you see the same thing in Preview?  Are you using the Google spreadsheet widget (versus gadget)?   Do you manually type the numbers in the Google spreadsheet?
Photo of Alex Kolenoff

Alex Kolenoff

  • 3,506 Points 3k badge 2x thumb
Yes, it does sound strange.  I am glad to hear it is working now!
Photo of Geoff Kruse

Geoff Kruse

  • 250 Points 250 badge 2x thumb
I actually figured it out! It has to do with formatting the columns. As soon as I formatted the columns, the leading 0s go away. I'm not sure how I'm going to work around this because if I don't format the columns, they don't look very good.
Photo of Alex Kolenoff

Alex Kolenoff

  • 3,506 Points 3k badge 2x thumb
You formatted the columns where, and what kind of formatting?  In the Google spreadsheet?
Photo of Geoff Kruse

Geoff Kruse

  • 250 Points 250 badge 2x thumb
I did the formatting in the widget settings. It just lets you choose how long each column is and then you can format the alignment. I was just making them center aligned to that everything was spaced equally apart. I can format the columns that don't have any leading 0s but the ones that do won't show them.
Photo of Alex Kolenoff

Alex Kolenoff

  • 3,506 Points 3k badge 2x thumb
Thanks Geoff.  I duplicated your steps and in the widget, I applied formatting to the column, and I see the issue.  I just logged a bug for this here:

https://github.com/Rise-Vision/widget-google-spreadsheet/issues/117
Photo of Blake Freeman

Blake Freeman, Official Rep

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

Just wanted to check in and let you know that this issue has some more eyes on it now. I'll keep up with this thread as I get news. 

Thanks!