46

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.


35

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 ...


30

The button to change the text wrap option is slightly hidden. Hence, adding a screenshot from the new Google Sheets UI.


11

Here is a regex based solution: = regexreplace( "Text", "(.)", "$1"&char(10) ) Translation: Look in the input "Text", which could be a cell reference too, and find each instance of the regular expression ., i.e., each single character. Store the matched character in a sub-expression so we can use it later by putting the regex within parentheses. Then ...


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"


7

It's official. This cannot be done. Like the other types of data and cell formatting, links in spreadsheets must be assigned to an entire cell, you cannot have just part of the text inside a cell be hyperlinked. The source document is linked to from edutraining.googleapps.com.


6

Google Spreadsheets uses 'грн.' to identify hryvnia. To use the currency Google tells us we need to: Select the range of cells you'd like to format or modify. Click the 123 toolbar icon. Select the number, date, or currency format you'd like to apply to the range of cells. You can also add Custom Currencies (like ₴) using the 123 menu as in the screenshot ...


4

As of 22 February 2017, support for rotated text will be introduced: Note Gradual rollout (potentially longer than 3 days for feature visibility) Reference Blog post reference: Support for rotated text in Google Sheets


3

What you're looking for is conditional number formatting. You can do this in the Google doc by highlighting the column you wish to format and clicking: Format → Number → More Formats → Custom number format... Thereafter, specify this as your formula: [<10]_(###0.00_);_(#0_) What it means is, if the cell value is less than 10 then format the cell in #,#...


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 -


3

If a cell is narrow, then here is a quick and dirty approach. Type the word into the spreadsheet cell with a space between each later: V e r t i c a l T e x t Then make the width of the column narrow so that text wrapping will stack the letters vertically. V e r t i c a l T e x t This will only work if the cell has a width of one letter. If the ...


3

You can combine a couple of the approaches suggested in some other answers by creating a custom function in Tools > Script Editor: function VERTICAL_TEXT(text) { var vert_text = text.replace(/(.)/g,"$1\n"); return vert_text; } And then using it in the cell: =VERTICAL_TEXT("cell contents")


3

You have a long header cell that you have rotated to save space. However, when the height of the row is shortened, a "long" value is effectively right-aligned so that the end of the value is shown rather than the beginning. As noted by @marikamitsos, it's not possible to do what you wish. However, wrapping the text is a good work-around to display the ...


2

Until we have real vertical test, it's the simplest to leave the text orientation horizontal and spread each heading over several cells using the cell merge function, in a stairlike fashion:


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

For now, I have worked around the issue by rotating the text down instead of up. Although this doesn't achieve the alignment aesthetic I wanted, it will suffice for now, and clipping end of value text works properly.


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 ...


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

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

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.


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