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)

13 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
4answers
953 views

Avoid decimal point when integer

Is there a way to use a custom number format in Google Sheets so that decimal point will be visible only when decimals are present? For instance 9 8,2 10 Is there a newer solution about achieving ...
1
vote
0answers
21 views

How can I add a thick borderline after a certain text in Google Sheets?

I'm trying to modify my Working Hours Spreadsheet; What I want to do is add a thick borderline after each Sunday, so I can better identify each individual Week of the Month. Here's the Masterfile ...
1
vote
0answers
1k views

Google Sheets text wrap no longer expands cell

All of a sudden I seem to be having trouble in my Google Sheets auto extending height of cell with text wrap, for certain cells. Mac OS: 10.13.6 (17G65) Chrome: Version 73.0.3683.103 (Official Build)...
1
vote
1answer
1k views

How to calculate time worked in Google Sheets after 12am?

I usually work from 3pm to 1am. I can't seem to find out how to make google sheets find the correct duration between those times. I know the correct duration is 10 hours, but no matter what I do ...
0
votes
0answers
11 views

Protect or Lock Particular Columns Formatting in Google Sheet

I have a file where we want to lock or protect multiple columns formatting to "PLAIN TEXT" . So if users copy and paste or paste as values should not alter the formats?
0
votes
1answer
15 views

Google sheet - highlihghting cell if in the same row other cell not empty

I'm trying to make a worksheet where I log shift hours. I made columns with dates and to each date a row of hours I want the date text to be green if in the same row a cell is not empty.. The code I ...
0
votes
0answers
20 views

Border Formating

I am looking to format cells with a border if the title cells both contain text. To trial I have used number 1 for the search key. I think it may be in the range I am supplying for the .setBorder. ...
0
votes
0answers
44 views

Utilize SI units in Google Sheets

Seven years ago this was asked, are there any new developments with regard to formatting with SI units? Normally, I will adjust the format to be all milli or micro simply by division, however my ...
0
votes
1answer
36 views

Google sheets spreadsheet will not format date correctly

I have a Google spreadsheet with a date column formatted to dd mmm yyyy. Many of the dates are formatted this way, but some cells will not format this way, and no matter what I select under "Format", "...
0
votes
1answer
39 views

Simplify fractional result of custom number format

In Google Sheets I would like to express any decimal number to the nearest 32nd of an inch. If I type 1.537 I want the result to be 1 17/32, but if I type 1.5 I need it to be expressed as 1 1/2 not 1 ...
0
votes
1answer
174 views

Show insignificant zero

I want, when I write a Number in a Cell, that the zeros are still visible. In a Google sheet. e.g. when I write 1.050, or 1.0 or 1.2000 there should stay exactly that. Not 1.05; 1; 1.2 or something ...
-1
votes
1answer
13 views

How can I search an argument in GSheets to return TRUE if the argument references another cell?

Hello! In some cells in the True Price Column, I applied a discount by referencing the cell Conv!C2. For example, the argument in D13 is =MROUND((D8 * 2) * Conv!C2, 5) where (D8 * 2) is me calculating ...
-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 ...