44

If there's a difference between 50 and 050, what you have are strings (i.e. text). Changing the cell format to Plain Text via Format>Numbers>Plain Text will keep leading zeros.


30

Since @jam 's answer there might be some improvement in Spreadsheet's features. If you'd like to preserve and use the numbers as figures (e.g., automatic fill) you might apply the settings from the Format > Number > More Formats > Custom number format... menu, and set the pattern to 000, where the number of zeros represent the number of digits to ...


7

A quicker way of formatting a cell as text, is to add a preceding apostrophe to your number. In a cell, type '050 and it will be interpreted as the string 050. Another option is to write it as a formula: ="050"


3

A1: =ARRAYFORMULA(JOIN("-",TEXT({"7/22","7/28"}+(COLUMN(A1)-1)*7,"M/DD"))) Drag to right. Two dates are initialized and a column number*7 is added per each column. TEXT to format dates " m/dd" JOIN the 2 dates by -


2

I needed to have a leading zero on the current month of the year for creating a custom date code I use on my invoices. This is what I did: =IF(LEN(MONTH(TODAY()))=1;CONCATENATE(0,MONTH(TODAY()));MONTH(TODAY()))


2

Possibly try a different approach. Don't use query but instead, in A1 and copied across to B1: =index(IMPORTHTML("http://www.thepowerof10.info/athletes/profile.aspx?athleteid=800922&viewby=date","table",18),,column()) Then either format ColumnB as Duration (and accept some extra zeros) or also use the plain IMPORTHTML as the source to copy format only ...


2

Set your start and end fields to time format (Format -> Number -> Time) and your time difference calculation field to duration format (Format -> Number -> Duration). Once you have done that you can just add and subtract times like normal number to get the time difference. However, you will get a negative time if one event stretches past midnight....


2

Here's a way to auto fill dates without erasing border format : Cell A1 1/1/2016 Cell A2 =ArrayFormula(ADD(A1,row(INDIRECT("A1:A"&30)))) Credit goes to Rubén For the 'name' column you can copy a the cell Claire for example then select the range where you need the name then paste values only. Shortcuts are CTRL+C -> CTRL+SHIFT+V ...


1

Select the cell(s) Click on Format > Number > More formats > Custom number format... On the box write something like #0.0E+00 Click Apply button Note: The leading # is to set an optional digit Reference Format numbers in a spreadsheet


1

Looking at you example spreadsheet the calculation in seconds is done with the following formula: =86400*(if(D4-C4<0,1,0)+D4-C4) This is the breakdown of the formula: time and dates in spreadsheets are floating point numbers. D4-C4 is subtracting the start time from the end time. The if statement is cheeking if the subtraction is negative, that ...


1

Did you try clicking on format options on the tool bar. Check the image the below where I have it highlighted. Highlight your cells,columsn,rows,etc. and make sure the format is set to number or automatic. Use the format you need.


1

Google Sheets doesn't include a setting to customize the text line height. One workaround is to set vertical align to Middle and change the row height to a size big enough. NOTES: When the OP says "lines" they actually are meaning rows. For multi-line cells, in order to increase the interline spacing, the workarounds are: Include a the size of one ...


Only top voted, non community-wiki answers of a minimum length are eligible