Skip to main content
The 2024 Developer Survey results are live! See the results

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
1 vote
1 answer
32 views

Editing the second line in all cells

I am creating a sheet in which the first column has two lines of text in every row. How can I bold the second line only in all cells without doing it manually as I already created the sheet.
Jaclyn's user avatar
  • 11
0 votes
0 answers
57 views

Can I use conditional formatting in google sheets to force cells to merge given a specific value [duplicate]

I am working on formatting a cash log for work (work in a restaurant and right now we record this by hand) the problem because each days entry isn’t uniform as the number of people working changes so ...
Rcyr1010's user avatar
-1 votes
1 answer
431 views

How can I get the same format of cells in my script?

I've made a script, but I need the numbers off 3 rows to be on percentage and I also want to use only 2 decimals and format the date (one of my table colums) as "yyyy-MM-dd". this is my ...
Leo's user avatar
  • 1
2 votes
2 answers
169 views

How to format ten thousands (만/万)

I know you can format thousands and millions by using a comma in the custom number format. However, I would like to format by ten thousand (man/wan in Asian counting system). For example 10,000,000 =&...
Patrick Yan's user avatar
1 vote
1 answer
17k views

Split / subdivide Google Sheets cell into multiple columns and / or rows

In Google Docs, you can insert a table, right-click a cell, select "Split cell", specify into how many columns (and / or rows) you want to subdivide the cell, and click "Split" to ...
some one's user avatar
1 vote
2 answers
182 views

Alternate colors with masked rows

In Google Sheets, it seems that masking an odd number of rows in a range somehow defeats the alternate color formatting (adjacent rows will occur with identical colors). Is there a workaround using, e....
jmichel's user avatar
  • 43
-1 votes
2 answers
16 views

Have a cell always populate a certain word but also hide the same column

I would like to hide column C called Type because the input field should always be the same. I know how to hide column C, but I also need column C to always fill with the word Retail so that it ...
Jimmy Wall's user avatar
2 votes
1 answer
329 views

Using INDIRECT and a cell reference to compare values on sheets

Simple story - driving me cray cray. I have a single Google Workbook with sheets within with separate names (Sheet1, Sheet2, etc). I have a separate sheet called Compare that I want to make formulas ...
Sanford's user avatar
  • 23
0 votes
0 answers
252 views

Importrange changes the format only for a couple cells

I am using importrange and for some cells google sheets changes the format of only a couple cells. I have attached a screenshot. The original worksheet has the correct dates M/DD/YYYY. So I am ...
Nicky's user avatar
  • 1
0 votes
0 answers
135 views

SI units in Google Sheets

In Google Sheets, I work with data spanning a few orders of magnitude, like mm (millimeter), µm (micrometer), and nm (nanometer). I wrote this formula for a custom number format using conditional ...
evanesco713's user avatar
0 votes
0 answers
114 views

How to recolor all cells based on the original color of the cell in Google Sheets?

I'm looking to recolor cells in a Sheets document I have, simply based on the original color that the cell already has. This is regardless of the contents of the cell and doesn't follow a traditional ...
Moop's user avatar
  • 1
1 vote
2 answers
101 views

Custom format that works for both 8 and 9 digits phone numbers

I want to format a cell to properly display phone numbers, but the number of accepted digits can be either 8 or 9. I am currently using the following format:"387" ## ### ### This works ...
Gepard Shop's user avatar
0 votes
1 answer
500 views

Trying to change Gantt chart in Google Sheets to highlight a cell based on date range and progress percentage

I have been working on a dynamic Gantt chart template in Google Sheets for awhile now. Here's how it currently looks: As you can see, the task bar currently highlights gray dependent on the start and ...
Stefanie's user avatar
0 votes
1 answer
1k views

I want date with yyyy/mm/dd format on Google Sheets

I want to convert mm/dd/yyyy to yyyy/mm/dd with function on Google Sheets. I applied TEXT function like the picture but it's not working. How can I convert this?
Atsushi's user avatar
0 votes
1 answer
35 views

How to highlight duplicate values when clicking on a specific cell

I'm new to spreadsheets, but trying to put a functional one together for my team. I have a list of member names, and several lists of tasks they are assigned on different days of the week. The goal is ...
Layson Williams's user avatar
0 votes
1 answer
1k views

How To Reformat Phone Numbers Within One Column? [duplicate]

I have a google sheet in which people's phone numbers are stored. I want them to be displayed in format NNN-NNN-NNNN, and to do this I like to store them in format NNNNNNNNNN set to display that way (...
Connor's user avatar
  • 101
0 votes
2 answers
351 views

How can I change the format to a popup calendar in Google Sheets?

I set the format in the cell to DD/MM/YY but when I click on that cell, I get a popup calendar with the week starting with Monday. But I want the calendar to start on Sunday. My Google Calendar is set ...
Sara Berzansky's user avatar
1 vote
1 answer
2k views

How to deactivate auto-formatting?

I was trying to type things in Google Sheets, but I can't find a way for the app not to automatically change some of the things I type. For example I can enter (-3000) in a cell and nothing happens, ...
Nathan's user avatar
  • 11
0 votes
1 answer
255 views

Google sheet currency (changable)

I was usually working on Excel sheets, in which I had option to choose currency (file was used as a template). It was based on Conditional formatting and simple formulas so it worked like charm. So it ...
Norbi Funghoburro's user avatar
-1 votes
1 answer
17 views

How could I copy information from multiple cells that share a common feature into one cell?

I have a list of codes that are each assigned to a specific bigger case code and I would like to put a list all of the smaller codes that share one bigger case code in one cell. for example D2-D6 are ...
distressed233's user avatar
0 votes
1 answer
47 views

How to jump to a specific customer name in a Google Sheet

I am trying to create a Google Sheet that lists all payments made for tuition by family. I would like to use only one tab (not create a tab for each family) as I have about 120 families to keep track ...
Tara Cash's user avatar
-1 votes
1 answer
518 views

Create a RAG system based on dates, upcoming and expired within Google Sheets

I want to create a RAG system in google sheets based on dates in a cell. Column A will show a date when someone is trained on a topic and column B shows the due refresher date (3 years later). I want ...
Simon's user avatar
  • 1
0 votes
0 answers
1k views

How to increase precision up to 18 decimals after decimal point in Google Sheets?

I want to have a number like this in my cell, 18 decimals after decimal point: 10.643958132611619777 But Google Sheets rounds it down to 13 decimals 10.6439581326116 How can I increase precision ...
Green's user avatar
  • 351
0 votes
1 answer
2k views

How to format numbers with a different thousand separator in Google Sheets?

On "Format->Number->More formats->Custom number format" there are several presets, and you can create your own. Great. So #,##0.0 yields results such as 1,234.6, ok interesting. But ...
o0'.'s user avatar
  • 366
1 vote
1 answer
7k views

Line spacing in Google Sheets

Is there a way to increase the line spacing in Google Sheets, not the cell padding? I'm referring to the space between the lines in a paragraph that's inside a cell. If not, is there an addon that can ...
Aryadne's user avatar
  • 11
0 votes
1 answer
49 views

IF/AND functions from multiple cells

Would anyone know how to fix this problem? I want cell A676 to categorize based on info from 2 cells C676 and D676. Basically IF the word "Paypal" is in cell D, AND there is a specific ...
Lloyd's user avatar
  • 1
0 votes
1 answer
46 views

Multiple IF functions on a single cell

How do I add multiple IF functions on 1 cel, without blocking it on the first line. As you can see, column D contains a bunch of text. In column A, I want to categories them. It works up until the ...
Lloyd's user avatar
  • 1
0 votes
1 answer
376 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 ...
Amir Kh's user avatar
2 votes
2 answers
9k views

Google Sheets - Hide Specific Cells (NOT Rows or Columns) based on Checkbox within a Sheet (Is this even possible?)

First off, let me say that I am as newbie as possible when it comes to Scripts and coding in general (up until last Friday, my experience was one class in C++ and some HTML back in high school...) so ...
EMC's user avatar
  • 21
3 votes
3 answers
1k views

File import into sheets is dropping necessary leading spaces

I have a configuration .txt file that I'm trying to upload into a new tab in an existing Google spreadsheet. I choose File>Import and select Insert new sheet(s), Detect automatically (there is no ...
kviLL's user avatar
  • 364
1 vote
1 answer
80 views

Editing cell value changes its formatting

Enter the value 18/04/2020 08:10:00 in a sell. Set the formatting of the sell to Hour(1):Minute(01) Actual value 18/04/2020 08:10:00 Display value: 8:10 Edit the value of the sell to become 18/04/...
yukashima huksay's user avatar
0 votes
1 answer
329 views

How can I have conditional formatting with lower priority than manual formatting

I know how to do the formatting that I want. The document should have conditional formatting. However When I added it. It covered the manual formatting. It there a way to say do this conditional ...
ctrl-alt-delor's user avatar
0 votes
2 answers
438 views

Google Sheets text rotated up, how to clip text end instead of beginning?

I have a very large table where the columns and rows are named, and interior cells are "1" or empty (essentially a sparse matrix). I have rotated the column header text direction up so that the ...
tboyce12's user avatar
  • 131
2 votes
1 answer
121 views

Pull data as a string from a hyperlinked cell in Google Sheets

I have utility that I've been working on (modified from an existing sheet) for a Tabletop game I run for my group. Currently, it generates random items from a list. The name of each of the items has ...
Kyle Chapman's user avatar
1 vote
0 answers
26 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 ...
Adrian Mignogna's user avatar
1 vote
1 answer
2k views

How can I paste HYPERLINK formula in Google Sheets cell, to make it clickable link with defined text?

I got a script that takes some data and prepares it to paste into Google Sheets cells, some of which are supposed to be links with custom text. But when I paste hyperlink formula the script created, ...
Human programmer's user avatar
1 vote
1 answer
8k views

Rich text formatting in a Google Sheets cell

How is it possible to enable "rich text formatting" inside a single Google Sheets cell? I'd like to have a cell containing some text with both bold and non-bold content, words in italic, with some ...
Basj's user avatar
  • 576
4 votes
4 answers
8k 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 ...
Riccardo's user avatar
  • 589
0 votes
2 answers
6k views

How can I make a formula ignore a blank cell in Google sheets

I am creating a budget template and have a formula that multiplies cells. However, not every cell will have a number in it. How do I make it so the formula will ignore blank cells or make them = 1 ...
Mary B's user avatar
  • 1
2 votes
1 answer
1k 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 ...
Krista K's user avatar
  • 203
3 votes
3 answers
2k 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, ...
Akababa's user avatar
  • 131
13 votes
3 answers
26k 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-...
BillyNair's user avatar
  • 283
6 votes
4 answers
5k views

How do I keep borders when dragging down to fill cells?

I have a large scheduling spreadsheet of dates and names, split up by week, with borders for clarity. I want to be able to autofill the dates by dragging down the cell. Sometimes I also want to fill ...
Declan Geoffrion Scannell's user avatar
1 vote
1 answer
358 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", "...
Helen Guenther's user avatar
0 votes
2 answers
615 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 ...
fred's user avatar
  • 135
1 vote
1 answer
661 views

Unsimplified Fractions in Google Sheets

How can I get Google Sheets to display fractions in the form I enter them, rather than in a simplified form? I'm trying to evaluate how a student did on a test, so I have one cell that reports the ...
Joseph Stevens's user avatar
2 votes
1 answer
8k 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 ...
user650654's user avatar
8 votes
3 answers
27k views

How do I Specify the Scientific Notation Power in Google Sheets?

In Google Sheets when I enter 10E-12 in a cell formatted for scientific notation, it automatically turns the number into 1E-11 Though technically correct, this is really annoying when comparing ...
Bunji's user avatar
  • 191
1 vote
0 answers
2k 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)...
user3871's user avatar
  • 263
1 vote
1 answer
62 views

Formating a number with specific spacing

I'm attempting to pull a particular option value from Yahoo! into Google Sheets. The base URL is: https://finance.yahoo.com/quote/GOOG190418C00800000 When breaking the formula up, I have to ...
BardsWork's user avatar
  • 137