Google-sheets – Show insignificant zero

google sheetsgoogle-sheets-cell-format

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?

Best Answer

add positions you need with a .00 button:
also you can set up a custom format number #,##0.0000:

Related Solutions

Google Sheets – Text Cell Formatting Question

I've created this little script to format the input:

function SCHANGE(array) {
  if(typeof(array) == 'number') {
    var number = array.toString();
  } else {
    var number = array.replace(/\D/g,'');
  }

  if(number.length != 12) {
    return "<> 12"
  } else {
    var first = number.substring(0,4);
    var mid = number.substring(4,8);
    var last = number.substring(8,12);
    var formText = first + " - " + mid + " - " + last;
  }
  return formText;
}

The script validates the input and converts it, checks whether 12 digits are given and returns the outcome. I've prepared an example file for you to play around with: formatted text.

Google Sheets – How to Decimal-Align Numbers

With the following custom number format, you are able to decimal-align numbers in Google Sheets, even by using fonts that use kerning.

Custom format

???.?????

Screenshot

custom number format

result

Example

I've added this solution in an example file: Decimal-Aligned Numbers