Questions tagged [google-sheets-cell-format]

Use for questions about Google Sheets cell format like formatting numbers, dates or using the equal, plus, minus symbols as part of texts (strings)

Filter by
Sorted by
Tagged with
7
votes
4answers
20k views

How to change the text line height in one cell?

I could not find an option in the recent version of Google Sheets to change the text line height (the spacing between lines in a single cell). You realize the problem even more when exporting the ...
8
votes
2answers
14k views

How to convert all numbers regardless of decimal separator into valid number of current locale?

I have a column with text looking like this: 123,123 123.123 123,123 123.123 I would like another column to parse this into decimal numbers, disregarding the different decimal separators (dot . and ...
2
votes
1answer
3k views

google cell format: only 3 digits

Is there any way to do this: I have cell and most of the numbers have 2 significant digits like 3.45. But once in a while I have a number like 143 big number, the rest are under 10. Currently for 143 ...
6
votes
1answer
13k views

Use specific currency symbol in Google Spreadsheets

'₴' is a currency sign used for the Ukrainian Hryvnia. It's in Unicode since 2004. I want to use it in spreadsheets as a sign for money values, but Google Spreadsheets doesn't understand it as a ...
39
votes
6answers
172k views

Google Spreadsheets automatically removes leading zeroes

I have a column comprised exclusively of numbers. Whenever I add 050, the sheet automatically changes it to 50. I have tried prepending a space, but it makes no difference. What can I do to avoid ...
8
votes
2answers
20k views

A Way to Add Text Before Your Hyperlink in Google Spreadsheets? [duplicate]

Is there a way to add text before the hyperlink? So for example: This section needs reworking. You can find the section HERE. HERE would be the text replacement for the actual link. The actual ...
2
votes
2answers
4k views

Hyperlinks in Google Sheets

In Google Sheets, it is possible to add a hyperlink to a cell as: =hyperlink("www.google.com";"search the web") This will show the text search the web which will hyperlink to Google. Can this rule ...
26
votes
11answers
130k views

How to alter text orientation to vertical in Google Sheets?

Using MS Excel I can go to Format of the cell and choose the text orientation from horizontal to vertical fairly easily. How do I alter text orientation to vertical in Google Sheets?
68
votes
6answers
241k views

Formatting a cell with word wrap without switching modes?

How can one format a cell to have word wrap in Google Sheets? I've tried Shift+Enter, but that doesn't seem to work. One thing I know works is to place the spreadsheet into List Mode and then if you ...

1
2