Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
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....


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

What I'm trying to figure out is how to take a price in the format of xx.xx or xxx.xx and add the correct amount of 0s to complete the link. =TEXT(A1, "00000.000") =ARRAYFORMULA(IF(LEN(A1:A), TEXT(A1:A, "00000.000"), )) =SUBSTITUTE(TEXT(G7, "00000.000"), ".", "")


1

custom number format: [<1000]0"";[<1000000]0,"K"


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

you need to lock it down with $ symbol otherwise it will be offset (like in your case) or not working as it should. the custom formula you are looking for is: =OR(WEEKDAY(B$4)=1, WEEKDAY(B$4)=7) applied to B4:I25


1

with one more column: cell A1: =TEXT(DATE(2018,7,15)+B1,"m/d")&"-"&TEXT(DATE(2018,7,21)+B1,"m/d") cell B1: 7 cell B2: =B1+7 and then drag down A1 and B2 https://docs.google.com/spreadsheets/d/


1

like this: =IF(AND(A1>9999999; A1<=99999999); "+"&"55"&" ("&"00"&") "&LEFT(A1;4)&"-"&RIGHT(A1;4); IF(AND(A1>99999999; A1<=999999999); "+"&"55"&" ("&"00"&") "&LEFT(A1;5)&"-"&RIGHT(A1;4); )) and then "00" / "55" can be referenced from a cell for ultimate comfort


1

closest you can get is to use 1+ column go to 123 or Format select Numbers select More formats select Custom number format... type: #,###.### and corect it with: =IF(RIGHT(A2;1)=".";SUBSTITUTE(A2;".";"");A2) https://docs.google.com/spreadsheets/d/


1

Manual way: Monday Tuesday Wednesday Thursday Friday Saturday Sunday Automatic way: 2.7 3.7 4.7 5.7 6.7 7.7 8.7 enter dates in cells select all cells go to: Format > Number > More Formats > More date and time formats... delete: .Month (8) hit those arrows next to Day (5) from dropdown menu select: Day as full name (Tuesday) press Apply button and you are ...


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