Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [formatting]

Styling information beyond the minimum of semantic elements: colours, styles (boldface, italic), sizes and special features.

0
votes
0answers
21 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 ...
0
votes
1answer
17 views

Stop Google Sheets formatting text as URL

When I type "product.name" or "product.id" into a cell, it's auto–formatted as a URL (different colour, underlined, hover shows it as an external link). But it's not a URL, it's plain text. Similar ...
0
votes
2answers
23 views

How to format code in Blogger

I am writing one article on Blogger, There I am unable to format code. The code I am writing is looking like simple text. The site name https://www.blogger.com/ I am using <div class="...
0
votes
0answers
10 views

Google Sheets Custom Number Format 'Broken'?

I somehow did this when creating a custom number format. Any idea as to how to fix this?
0
votes
0answers
10 views

Google Sheets Conditional Formatting

I'm trying to finish up a Google Sheet with some conditional formatting that I can't figure out. Here's the best description I can come up with. If Column A matches in any row, then the formula ...
0
votes
0answers
26 views

How to set a single page's properties? [duplicate]

The goal is to selectively configure a single page of a multi-page document to: landscape (hyperlink to similar, yet a subset of this question) and paper size A3. The hope is that the link is ...
0
votes
1answer
69 views

How to change the default font & font size in Google Documents? [duplicate]

I really hate Arial, which happens to be the default for Google Docs. Does anyone know if there is a way to change the default font and font size in Google Docs? Thanks.
2
votes
0answers
13 views

How do you change the default indent and set your own in Google Documents?

I don't like how the default when you open a new Google Doc is no first line indent. Is there a way to customize the default?
0
votes
0answers
23 views

How do I shift all of my words, so they align only in the left column?

How do I shift all of my words into the left side of the column without just repeatedly using enter? I'm trying to do some qualitative coding, so all of my interview transcripts need to go on the ...
0
votes
1answer
32 views

Formula for custom number format in Google Sheets (e.g. 5M --> 5,000,000; 50k --> 50,000; etc)

I've been trying to figure this out for a bit but everything I've tried doesn't work. A quick search brought me to the conversion from full number format to condensed format (5,000,000 --> 5M; 50,000 -...
0
votes
1answer
387 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....
1
vote
1answer
315 views

Weird behavior with “Wrap Text” in tables

I'm trying to add an image at the beginning of cell of a table that Wraps text however, for some bizarre reason it seems also block out space in the cell to the right. Where as, I'd expect something ...
0
votes
1answer
528 views

Google Docs date in yyyy/mm/dd format (year first)

My question is similar to Google Docs date in “dd/MM/yy” format and How can I change the input format for dates in Google Docs' spreadsheet? BUT unlike those answers, I'm trying to get the ...
1
vote
1answer
17 views

What's the shortcut key for code block?

How to format a selected piece of text as a code block in slack?
1
vote
0answers
28 views

How can I get a custom outline numbering template in Google Docs?

I've seen a few questions around about what I thought was outline numbering, but instead was about headings. I'm specifically talking outline number formatting. I wish to make an outline in the ...
0
votes
0answers
24 views

Protect the Formatting on a public Google Sheets Spreadsheet [duplicate]

I have a shared spreadsheet that users can edit data in. The only problem is, that whenever someone copy and pastes data, the format changes, and I'm always going in to fix it (somewhat of a pain). I ...
0
votes
0answers
10 views

How can I create a web Form which allows me to display each question on a single line? [duplicate]

I want to conduct a recognition task for Chinese characters online. People who fill out the task will have to read the Chinese character, and type out the pronunciation of the character in English ...
1
vote
0answers
97 views

how export a PC build to a spreadsheet

PC part picker has an export to HTML button, which is all fine and dandy. I would be more interested in exporting to an actual spreadsheet, however. Google sheets would be fine, or CVS, anything ...
6
votes
4answers
921 views

How to left align dollar symbol but right align number?

I selected format -> number -> more formats -> custom number format: $#,##0_);[Red]($#,##0) How can prepend spaces between the $ symbol and the digits? Pad with spaces. So that the dollar sign is ...
1
vote
1answer
1k views

How can I format a pivot table with staggered elements to make narrower?

Right now a typical pivot table looks like this: This takes up too much room horizontally. I want to format it so that it is narrower and taller, by moving nested blocks down and left. How can I ...
2
votes
1answer
30 views

Unconditional formatting universally applied in Google Sheets

How do I change the default color for anything which I type into Google Sheets? When it's a URL it seems to go to one color, when not, another. I'm not looking to delve into JavaScript. I just ...
3
votes
1answer
53 views

Make each cell in a column update from the same row of another sheet?

I'm looking for a function I could apply to a column that would make each cell in the column check the value of the first cell in its row and the first cell in its column and then return a value from ...
3
votes
1answer
702 views

Auto-fill date function changes the YEAR and not the day

I'm trying to get Google Sheets to auto-fill dates in the beneath cells after I have manually filled one myself. The strange issue is that when I hold Command key and drag down, the cells auto-...
-1
votes
1answer
23 views

How to change formula output directly?

I have a formula which produces some text, how do I highlight a part of the text to change the part's color?
6
votes
3answers
6k views

How to create a checkbox column, that if selected will create a strike-through across the entire row in Google Sheets?

I have a Google Sheets. I want to set it up so that the first column is checkboxes, and if the checkbox is selected, the entire row gets a strike-through. How can I accomplish this? I followed this ...
3
votes
1answer
417 views

How to change number stored to a plain text format in Google Sheets?

I have numbers stored in a sheet as (xxx) xxx-xxxx. I want to remove all formatting and make it just xxxxxxxxxx. How can I accomplish this?
1
vote
1answer
134 views

Creative Cognito Forms notification email that contains all form details

I would like the email that I receive as a notification from a Cognito Forms entry to have the same formatting as the PDF document I can download. I would want it to look like the form as it is being ...
1
vote
1answer
22 views

Different appearance for different GPS pins in CommCare's map reports

I am developing a map report in CommCare's report builder. I would like the different GPS points on the map to have a different appearance depending on a filter. For example, if the client at the GPS ...
3
votes
1answer
5k views

Entering mm:ss: milliseconds into Google Sheets for time duration (arithmetic)

I would like to enter times mm, seconds, milliseconds into Google Sheets and subtract times to determine duration. I use format> numbers > More formats > more dates and times > and apply mm:ss: ms. I ...
1
vote
1answer
178 views

Custom number format for large dollar amounts (positive and negative)

I'm trying to create a custom number format that will display big dollar amounts with the typical k/M suffixes. Examples: $1 $12 $123 $1.2k $12.3k $123k $1.2M $12.3M And, actually, I partially ...
-5
votes
1answer
39 views

How do I apply text effects like this in “The Three Evils” [closed]

I know there's an online utility that does it but I can't seem to find it. All my Googling has been in vain. The T̜͓̞̤͎ͦ́ͤ̓̄̚ḣ͖͙̘ͦͯ̾re͗̈́e ̙̥̘̙͉̺̜̐ͧ̍E͍̲̜͈͊v̹͙̝̗ils is the only example I could find of ...
1
vote
0answers
389 views

How do I format links in Google's My Maps location descriptions?

Google's My Maps supports the placement and customization of locations in its map edition, including the ability to add a "description" to added locations. However I don't see how to format links ...
1
vote
1answer
968 views

Can Google Docs auto-correct capitalization?

In Microsoft Word, you can change capitalization in a document using the Change Case button. It includes options for Sentence case, lowercase, UPPERCASE, Capitalize Each Word, and tOGGLE cASE. Does ...
2
votes
1answer
8k 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
1answer
123 views

How to color an adjacent cell based on a 6-digit hex number without adding the “#”

I've looked at a few things (this link, WA's Colorize a cell in Google Spreadsheets based on cell data, and this link), but haven't been able to quite get the behavior I want in Google Sheets. What I ...
1
vote
0answers
25 views

G. Classroom Format Off

I have 14 students working in Google Classroom. One student is having this issue. When he "Creates" a document through the Google Classroom assignment stream, the document formatting is tiny and ...
3
votes
1answer
345 views

Custom Number Format for scale-aware number formatting in Google Sheets (e.g. 1,200→ 1.2k; 1,200,000 → 1.2M; 1,200,000,000 → 1.2B)

Does anyone know a generalized Custom Number Format I can apply in Google Sheets such that numbers appear with it's scale operator and rounded to one decimal place? Example: I looked up a good ...
2
votes
1answer
166 views

in Gmail COMPOSE EMAIL, how can I alphabetize a list as part of an email?

In MS Word and MS Outlook, I can alphabetize a list inside an email (using the AtoZ macro) - but I can't find how to achieve this in Gmail web browser client. Is it possible to do such advance edits ...
2
votes
1answer
3k views

How to enter leading Tab in Google Docs

I have two images and two labels: |--------------| |---------------------| | | | | |--------------| |---------------------| ...
0
votes
1answer
149 views

I cannot make text white in Google Sheets

I am trying to make text white in a Google Sheets. I select the text, changed its color to white: ... and when I click in another cell or press Enter to validate, it goes back to the base color: ...
0
votes
1answer
75 views

Excel spreadsheet into body of Gmail message without losing formatting

I am trying to copy and paste an Excel spreadsheet into the body of a Gmail message. I know I can attach it but the recipient can't receive attachments. The formatting stays but not the borders/...
1
vote
1answer
745 views

How to use strike-through style in the Flowdock chat?

Is there any possible way to use the strike-through style in the Flowdock chat, like * for italic, ** for bold. In the help page for formatting, I didn't see any way to use the strike-through style.
1
vote
2answers
55 views

How can I enter a date in the format I choose?

I am trying to create a spreadsheet with 5 sheets, there is going to be a date entered on sheet1, which will have a date+1 for the sequential days, i.e enter Monday's date and the following dates will ...
0
votes
1answer
331 views

Google Docs Markup When Posting into WordPress?

I write in Google Docs, then paste the content into WordPress. When I look at the HTML in WordPress, it has some extra markup added: < h2 >< b >Testing< /b ></h2> < span ...
2
votes
1answer
94 views

Google sheets recently changed American datetime format, how do I change it back?

Google sheets recently changed American datetime format, how do I change it back? It used to default to using "MM/dd/yyyy" but as of a couple weeks ago now when I enter a date it defaults to "MM/dd" ...
9
votes
5answers
16k views

How NOT to bold text in WhatsApp & still use ** around text?

Now as WhatsApp offers options for bold, Italic & strike-through text, how not to make the text bold while still enclosing it in *. Any kind of escape character? For example: *test* will result ...
7
votes
2answers
6k views

In Google Sheets, how does one get a 12-hour time of day *without* an AM/PM indicator?

I am trying to display times in Google Sheets without an AM/PM indicator, but with 12-hour time (not 24-hour "military-style" time). I do not need the AM/PM indicator as it is redundant in my ...
2
votes
0answers
83 views

For Google Docs tables, how can we make an incomplete row have no bottom or top border (to show that it is incomplete on screen and on paper)?

When we use Google Docs and create a table, sometimes a cell can span across two pages. So for example, I can write a few lines (with Enter (line breaks)), and then, either on screen or on paper, the ...
4
votes
1answer
502 views

Formatting Google Sheet Dates Inconsistent

I have a sheet where various data is entered through a form. Dates are picked on the form using the standard date picker provided by Google Forms. Some dates in a column I can change the date format ...
2
votes
0answers
931 views

How can I insert a text item (question) with multiple response fields (and descriptions) in Google Forms?

I'm trying to create a survey/Google Form specifically to export data into an Excel sheet. This isn't very important because I can tweak the arrangement after the fact, but naturally I have a lot of ...