Can anyone help bish s out? On his post, not mine.

By

Can anyone help bish s out? On his post, not mine.

Originally shared by bish s

Google Spreadsheet Question

Does anyone know how to format an integer such they are presented with leading zeros? For example to show the number 6 as 0006.

Comments

Scott Jonker said…
treat the cell as text
May 4, 2012 at 1:12 PM
bish s said…
See how I did it in my post. :)
May 4, 2012 at 1:40 PM
Post a Comment

Popular posts from this blog

So, I asked Andrew Tamm, who filled my Stream with a hundred (sarcasm there) animated gifs and cat pictures to...

By
So, I asked Andrew Tamm, who filled my Stream with a hundred (sarcasm there) animated gifs and cat pictures to remove me from whatever Circle he has me in where he posts the animated gifs and cat pictures. It was either that or unfollow him and I didn't see any reason to unfollow him. Me asking https://plus.google.com/112885755521259735422/posts/78dwnvvgh4p <==edited to add the correct link Then he plusses me onto Public posts of animated cat gifs : https://plus.google.com/u/0/112885755521259735422/posts/EuuR1tnU3vJ https://plus.google.com/u/0/112885755521259735422/posts/8r6Grcm2Jpj https://plus.google.com/u/0/112885755521259735422/posts/74PgSu6iL2s Then one of his friends (or Circlers) starts plussing me into posts of animated cat gifs : https://plus.google.com/u/0/107120198886093172821/posts/gRW9JhWLs5T Don't get me wrong, I'm all about sarcasm and messing with people, but this seems sort of childish to me. Am I the only one who thinks so? So far I have only blocked
Read more

I'm shutting down Google+ for the night and quite possibly for the weekend.

By
I'm shutting down Google+ for the night and quite possibly for the weekend. Why? This stupid #gifwars thing people are so proud of. This Adam Black guy said he doesn't like gifs and now everyone is mass trolling him. Having been mass trolled like this I can relate to him easily enough. Have an opinion and the collective might of Google+'s lower class denizens jump on a bandwagon. I just saw a post where someone wanted to jump on board and had to get clarification she was tagging the proper Adam Black. She wasn't even connected to him ! Nor was she a part of the original discussion. She just wanted to follow the herd. When I called her out of it she claimed, "one gif doesn't make a troll." Perhaps not, but she's contributing to a larger troll effort. One straw doesn't break the camel's back, but thousands will. So, tonight, Google+ disgusts me. It probably will tomorrow as well. And possibly Sunday. I gave up Google+ for two months this spring
Read more