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)
12
questions with no upvoted or accepted answers
2
votes
3answers
39 views
Google Sheets: avoid decimal point when integer - [Bug discovered?]
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
43 views
How do you “Paint Format” more than once in Google Sheets?
In Google Sheets you can select a formatted row, click the "Paint Format" Tool, then click another row to apply the same format. You can drag down to do multiple rows if they are together (say rows 50-...
1
vote
0answers
653 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
848 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
10 views
Change entire sheet information based on input of one cell
I'm trying to create a function on a secondary sheet to monitor which of my blogs are getting the most traffic. Currently my secondary sheet has a formula that works to show me blogs that have over ...
0
votes
0answers
18 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
29 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
20 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
0answers
50 views
Validation of cell values
I have a problem (like everyone here, obviosly). In the sheet in the column E from row 2 (row 1 is the heading) I have to choose some text: Text1, Text2... Depending on the choice of value (it should ...
0
votes
1answer
120 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 ...
0
votes
1answer
917 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 ...
-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 ...