Google Sheets - Custom Number Formatting

Have full control over the visual presentation of your numbers. We will cover alignment, currency signs, color, arrows, and much more.

🕒 Timestamps
- 0:00 - Basics
- 3:17 - Balance Sheet - Currency, alignment, rounding, borders
- 6:41 - Changes - Colors, arrows
- 11:30 - Next video: Conditional formatting

Learn more from Prolific Oaktree:

#googlesheets #customnumbers #tutorial

[starcluster]

i have the 1, 0000 type on but it keeps doing 310.*** and not 3.1*** and its so frustrating please help

[francesco]

In my case I've got the "." to split then thousands and the ", " for the decimals, I'd like the opposite just like it shows it on you, how can I do that? thanks in advance

[sagrindentertainment]

How can I change the color from 1 to 30 so everything in that certain range will be one color?

[vincentrouilhac]

Awesome tutorial thanks! But how can we git a custom formatting a name ? It appears as so in the dropdown :/

[DiogoSilva]

Hey, how can i eliminate a costum number format that is no longer in use?

[Layarion]

I want 0.? but also to hide the decimal if there is no decimal

[dyako]

number format not working no change in numbers rows?

[airecai-poweredrecruitment]

Instead of adding '0' to number format, I need red and green arrow to appear if the current value is lesser or greater then the previous cell, how do we change formula in this care?

[Metalmachine]

If you can tell me how to do this ill love you forever.
I have a custom number format to put "@ " in front of any number I type (Format is "@ "0, e.g. I type '5', it presents as '@ 5'. But sometimes I want to use a number range e.g. 5-6 or decimals e.g. 5.5. And I can't find a way to make this work (decimals can do "@ "0.0 but then it displays the round numbers as '@ 5.0'. I really just want it to put '@ ' in front of whatever I type afterwoods

[namehere]

In Google Docs, how do I delete a blank page (how do I prevent the blank pages from appearing again), how do I lock formatting on/to a specific page, how do I lock the formatting for/on the entire document, how do I select and use a font like wingdings, how do I wrap text to the cell of a table, how do I drag and re-size tables as needed without them messing up the next page?

[usmansarwar]

Hi can we give a cell reference in custom number formatting?

[fernandodanielbonaudi]

Hi!. I hope you are doing well. Nice and useful video but unfortunately I'm having a issue. I'm try trying to format a Data Time cell but my google sheet does not show me in the Format --> Number menu the option "More formats" so I can reach the "custom number format" option. Do you have any clue why is that and how to solve it? Thanks a lot!

[sahilmanocha]

Hi, How can I get the editable copy of the sheet you are using? (I want to practice all that formating). Thanks.

[sacredgeometrix]

Hey there! Our team works with fractions down to the 16th. Do you know a way of number formatting or creating rules that if a number value is .5 it'll show as 1/2 versus if it's something like .6875 it'll read as 11/16; versus if it's .375 as 3/8; or finally something like .75 as 3/4? I'm actively researching this capability but hoping for anyone that would know better at this juncture. Thank you for your time!

[quickpickle]

What if you want decimal first and comma after? For example in some european countries the number 1500 euros and 10 cents would be written 1.500, 10

[mbwa]

how to add country code with custom format ?
like 60

[MilanKarakas]

There is no hope. The signal was expressed in values as is: 0.000107358, but no matter what, it is just 0. Damn!