I want, when I write a Number in a Cell, that the zeros are still visible. In a Google sheet.

e.g. when I write 1.050, or 1.0 or 1.2000 there should stay exactly that. Not 1.05; 1; 1.2 or something like 1.0500; 1.0000; 1.2000.

I just want, that the Zeros where I write in the cell, should show and not be removed. Moreover, the cell type shall not be a String, because I want to sort the Data, after the Value from the Numbers. I have tried to create a custom Format, but I am failed.

Now somebody, how I can do that?

  • add positions you need with a .00 button:

  • also you can set up a custom format number #,##0.0000:

  • This I already know. The Problem is, that I write with a Python Script Automatically in the sheet, in more than 100 cells and I don't want to make this all by hand.
    – Nogrod
    Feb 19 '19 at 19:43
  • and I need in different cells a different number of insignificant zeros and bye every Update I also need maybe a different number of zeros in the same cell. So I have do this automatically
    – Nogrod
    Feb 19 '19 at 19:46
  • @Nogrod answer updated
    – user0
    Feb 19 '19 at 21:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.