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

learn more… | top users | synonyms

1
vote
0answers
7 views

Formatting time duration “d, hh:mm” to display correctly when positive and negative

I use Google Sheets for my timesheets. I enter time I start working, time I end and duration of break. Daily time spent is then being calculated (i.e. column D). That all works. But then I have the ...
2
votes
1answer
85 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 ...
9
votes
6answers
100k views

Can I add a line break in my Twitter bio?

My Twitter bio looks bad because the line is split at unfortunate places. Can I force a line break at a particular place? The form at https://twitter.com/settings/profile inserts a carriage returns ...
2
votes
1answer
19 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" ...
58
votes
3answers
8k views

Setting up Gmail to use Markdown to read and send out emails

I've become rather fond of Markdown and think it would be rather well suited to emails. How do I set up Gmail to allow me to format reading and sending emails in Markdown? Is this even possible? If ...
0
votes
0answers
46 views

How can I format nodes in a Google Spreadsheets organization chart?

Google Charts allows users to format organization chart nodes using HTML. (Awesome.) I can't seem to find a way to format organization charts in Google Spreadsheets. I'd already be happy having a way ...
14
votes
5answers
11k views

Can you add basic text formatting (bold, italic) in Yammer posts?

When writing a post (or a comment on a post) in Yammer, is there any way to add basic text formatting such as bold or italic text?
23
votes
14answers
70k views

Insert a table in Gmail

How can I create a table in a Gmail message? I've currently got the data in a Google Docs spreadsheet, but copying and pasting that into the Gmail editor just pastes tab-delimited columns, not a table....
25
votes
3answers
96k views

How do you format Facebook Wall posts?

There doesn't appear to be any formatting links when I do a Facebook Wall post. Is there any way to do formatting like HTML, markup, etc?
11
votes
5answers
8k views

Always a blank line above where I insert a table?

In Google Docs, when I insert a table, there seem to be always a blank line above the table. See the screenshot below. How do I prevent that?
19
votes
13answers
39k views

How to set a Google Docs Spreadsheet cell format to bare text?

I am to store international standard phone numbers (starting with a plus sign followed, usually, by plain numbers) in a Google spreadsheet column. An example of such a phone is +420123456789 When I ...
7
votes
2answers
12k views

How can I put an equation into a Google Docs Presentation and maintain the formatting?

I read a similar question on the Google Docs Help forums, but if I copy an equation that contains a symbol without using an image (such as the ∈ symbol), the symbol goes away in the presentation. Is ...
8
votes
2answers
8k views

Is it possible to format small-caps in Google Documents?

I have found the need to format text in small caps (with minuscule letters looking like capitals, but still maintaining their size) in Google Docs. I have looked over, under, and in the Docs option ...
3
votes
3answers
17k views

Google Docs is altering my formatting, how can I avoid this?

I don't have a printer and I need a document printed. Thus, I've shared a very basic Google Docs document with someone who does have a printer. Over here the formatting looks fine. Tabs are correct, ...
6
votes
2answers
17k views

Why is Gmail rich-text formatting so inconsistent when replied to via Outlook?

I use the Gmail web client with rich-text and often find that my emails look to be formatted consistently when I send them, however when Outlook users reply, the text in my original email often has ...
23
votes
2answers
2k views

How do I change date and time formats in Trello?

How do I change the formatting of time and dates in Trello? I'm looking to change the following: time presentation to 24 hour clock instead of 12 date format to DD/MM/YY instead of MM/DD/YY?
6
votes
3answers
3k views

Google Spreadsheets date and time format

I have lots of dates in the first column in the format August 23, 2010 at 11:01PM I was wondering if anyone knows a way to get them formatted in a way that I can then use for date and time ...
10
votes
3answers
9k views

Cell reference with colour formatting

Is it possible to reference a cell in Google Spreadsheets so that cell where it gets displayed also displays it using the same text and cell colour formatting? =A1 Will only reference dell's value. ...
6
votes
2answers
328 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 ...
3
votes
3answers
9k views

How do you post a Facebook Note in a group or on a page?

To make formatted posts on Facebook you have to use Notes. This is fine for posting on your wall, but how do I post a Note to a group or page, or is it impossible to post a formatted post using those ...
3
votes
2answers
9k views

Keep Formatting When Pasting to Gmail

I liked formatting my e-mails in MS Word and then copy and paste them into Gmail. I did it, among other things, because I could control line spacing and text alignment (I prefer it justified). Gmail ...
11
votes
2answers
7k views

How to change the default style of text links in Google Docs

I want to format the default style for text links—currently the color is blue & are underlined. Is this possible? And if yes, how can I do it?
4
votes
1answer
333 views

How to add a line break in a custom date format in Google Spreadsheets?

Google Spreadsheets give us a tool to create and use a customized data format for date values. While the tool allows us to use arbitrary characters, like slashes and commas between the date fields (...
6
votes
3answers
9k views

How do I mix formats in one cell?

I've got a string like ="Daily Avg: " &AVERAGE(C3:C13) I'd like to be able to apply number formats within my cell's formula. Is this possible without custom scripts? I've searched Google's ...
19
votes
6answers
26k views

How to center a table in Google Docs?

Centering data within a table cell or cells in Google Docs is straightforward and easy (highlight and center). But how to center an entire table? This should be easy, but it isn't. I can't for the ...
2
votes
0answers
83 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
240 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 ...
1
vote
7answers
10k views

Some incoming Gmail messages do not word wrap

I've noticed that in Gmail some incoming emails do not word wrap. This is quite annoying as I have to navigate the cursor horizontally to read the message. Some people think that the sender's email ...
4
votes
0answers
49 views

What's the full range of supported Google Docs LaTeX macros?

Google Docs has an equation editor that has a fair number of options for symbols and functions available from the dropdown menu. All of these are also available through LaTeX macros that are ...
2
votes
1answer
117 views

Italicize one word and not others in draw.io

I am using draw.io to make diagrams related to genetics. It is convention in my field to italicize gene names. I would like to have a box that says "genename::cDNA" where "genename" is italic and "...
4
votes
3answers
4k views

Using the Google Documents equation editor, how can I enter the binomial coefficient?

It does not appear that you can enter the binomial coefficient or the choose-function of combinatorics. I'm trying to use the parenthesis in the third drop-down menu in the equation editor, but they ...
2
votes
1answer
97 views

How to convert all numbers regardless of decimal separator into valid number of current locale in google sheet

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 ...
5
votes
3answers
8k views

How do I Insert a carriage return on a card in Trello?

I have added a card to a board in Trello, and now need to edit the text on that card. How do I insert a carriage return? I have tried the following: Shift + Return Ctrl + Return Shift + Ctrl + ...
1
vote
1answer
247 views

Cell formatting in Google Spreadsheets does not get preserved

My Google Spreadsheet does not preserve some formatting. Every time I set, for example font size to 12, for the whole sheet, newly copied data uses a smaller font size. This only started being an ...
5
votes
1answer
690 views

Formula for smart, scale-aware number-formatting in Google Sheets? (e.g. 1,024 → 1k, 1,816,724 → 1.8M)

Any recipes out there for a "smart" number formatting formula for Google Sheets that's "scale-aware," a la Rails ActionView's distance_of_time_in_words method? I would expect to enter a number like: ...
1
vote
1answer
63 views

Blogger: How can I add a “Code” paragraph type?

Blogger paragraph types are Normal, Heading, Subheading, and Minor Heading. How can I add a Code type that will set a small, bold, fixed-width font?
3
votes
1answer
1k views

How to make bullet sizes match in web app vs printed in Google Docs when using a non Arial font?

I've come to realize that seemingly only Arial font will print my Google Doc bullets in the correct size. If I use a different font, this happens: In browser: Printed/downloaded to PDF: Notice ...
5
votes
2answers
1k views

Format credit card numbers as four digit blocks in Google Spreadsheets

I have this credit card number in a Google Docs spreadsheet of the following format: XXXXXXXXXXXXXXXX How can I make it display like XXXX XXXX XXXX XXXX or XXXX-XXXX-XXXX-XXXX where they're in ...
2
votes
1answer
90 views

google cell format: only 3 digits

Is there any way to do this: I have cell and most of the numbers have 2 significant digits like 3.45. But once in a while I have a number like 143 big number, the rest are under 10. Currently for 143 ...
5
votes
4answers
12k views

Inserting page numbers in a Google Docs document

How do I add or insert a page number in the footer or header of a Google Docs document?
0
votes
1answer
81 views

Format link to Wikipedia page about an essay or chapter title

For books and movies it's easy: surround the link in pairs of single-quotes to italicize it. For example, Lord of the Rings. ''[[Lord of the Rings]]'' But according to "Which Titles Are Italicized ...
9
votes
2answers
2k views

How can I format text as code in Inbox by Gmail?

I sent an email today (or wanted to) from Inbox by Gmail and was disappointed at the apparent lack of ability to format text as code when compiling an email: How can I format text as code (or ...
2
votes
1answer
1k views

How to make a protected range appear normal in Google spreadsheets

I have a project in Google spreadsheets shared with several other users. There are sensitive formulas throughout that I have protected to prevent accidental deletion or overwrite by the other users. ...
1
vote
2answers
2k views

Issue with Custom number format in Google Spreadsheet

I have a number cell formatted in this way: #,#" days";. Nevertheless, if I write 1.5the output is 1 days even if the content is still 1.5. Otherwise, if I write 1,5 the output will be as it is 1,...
0
votes
1answer
258 views

What's the best format for multi-word hashtags in tweets? [closed]

What's the best format for multi-word hashtags in tweets? Some candidates for consideration are, supposing a phrase's normal writing is "foo Bar baz": #FooBarBaz (camel-cased) #foo_Bar_baz (...
3
votes
0answers
225 views

Permanently enable plain text mode in Yahoo! Mail

The last button (icon) in the image below is Switch to Plain Text mode. It fits perfectly with my needs. How can I permanently switch to plain text mode? (If there is no such feature, I guess I ...
41
votes
3answers
20k views

What are all the formatting options for a Google+ post?

What is the markup language for creating posts (and responding to posts)? I know of the following ones: To make text bold, use stars around the text: *bold text* To make text italics, use ...
6
votes
2answers
5k views

Formatting bullet lists in Trello

The cards description field in Trello says they are supposed to accept markdown. However, I can't seem to be able to use stars to format a bullet list. All my text is put on a single line, with ...
43
votes
2answers
20k views

How do you manually block-quote in Gmail's new compose interface?

Gmail recently released a new UI for compose. How do you manually quote a paragraph? The block-quote button seems to have disappeared from the formatting toolbar in the rich text compose editor.
1
vote
1answer
700 views

Date format in Google Spreadsheet is not correct

Whenever entering the date e.g. day-month-year, it automatically changes to month-day-year. I went into format>number>more formats>more date and time formats, and I changed it to day-month-year. And ...