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
9
votes
1answer
27k views

Can I protect the formatting of a Google Sheets?

I’ve got a Google Sheets that has lots of formatting and formulas, in various columns, some columns are formula driven, and some columns that are user input driven. The spreadsheet is shared with ...
1
vote
2answers
7k views

Image in a cell with a hyperlink

I need a cell that contains an image to also contain a hyperlink. Following formula is the only one I found but doesn't work (error analyzing formula) =HYPERLINK("URL", image("URL")) Following ...
67
votes
6answers
239k 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 ...
6
votes
4answers
16k 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 ...
3
votes
3answers
383 views

Entering fractions verbatim in Google Sheets

I'm trying to put some marks in a spreadsheet and have a lot of unsimplified fractions or fractions like 19.5/20. Is there a way to enter fractions and have the cells be usable in other formulas, ...
5
votes
1answer
10k 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 ...
3
votes
3answers
3k views

How can I open multiple URLs in Sheets using one cell?

I have been frequently using concatenate to combine cells and strings to render URLs in cells. The purpose of these URLs is to open specific pages to review the information on those pages. I am ...
39
votes
6answers
169k 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 ...
5
votes
1answer
9k views

How to remove insignificant decimal point in Google Spreadsheets?

I'm trying to format a number in Google Spreadsheets. I want it to show the thousands comma, then a period ., followed by mostly 3 digits, only when necessary. For example: 1,234.56789 => 1,234....
7
votes
1answer
11k 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 ...
-1
votes
1answer
1k views

How to format a negative number red within a mixed formula result

We use the following formula: ="Stu/W: " & TEXT((A$2/B2),"[Red]#,###,##0.00") &"€" and wish to have the resulting negative currency numbers colored red and positive blue. Unfortunately ...
8
votes
2answers
19k 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 ...
0
votes
1answer
897 views

Partial cell formatting with CONCATENATE in Google Sheets

Is there a way to format partially using CONCATENATE in Google Sheets? For example, =CONCATENATE("*", Sheet1!A1, Sheet1!B1), and I want to make the * bolded or blue in color or something else. I ...