Excel - AutoFill Section 1, Section 1.1 Using Custom Number Formatting for General - Episode 1769

1,656 views · Published 8 August 2013 · 3:05 · Indexed 28 October 2026

Channel: MrExcel.com · 2013 · Education

Watch on YouTube

Microsoft Excel Tutorial: Toggle Decimals in Custom Number Formats | Excel Tips & Tricks.

Welcome to another episode of the MrExcel podcast. In this episode, we will be discussing the General Format in Excel and how to toggle decimals in custom number formats. This is a common issue that many Excel users face, and I am excited to share a solution with you.

Recently, a question came in on YouTube about using Autofill to fill in numbers in a specific pattern, such as 1, 1.1, 1.2, and so on. Unfortunately, Excel does not have a built-in feature to do this automatically. However, with a little bit of creativity, we can achieve the desired result.

First, we will use the pattern 1, 1.1 and copy it down. This will give us the correct numbers, but we also want to include the word "Section" before each number. To do this, we will use the Custom number format and enter "Section 0.0" in quotes. However, this will also add a decimal point after the number 1, which we do not want. So, we will use the question mark symbol instead of the zero to tell Excel to only include the decimal point if needed.

But wait, there's still one more issue. The numbers in the first section should not have a decimal point at all. To solve this, we will use the word "General" in our custom number format. This may seem counterintuitive, as General is a default number format in Excel, but it actually allows us to achieve the desired result without having to use conditional formatting.

So, there you have it - a simple solution to toggle decimals in custom number formats. It may be a two-step process, but it saves us from having to use more complex methods. I hope you found this tip helpful and thank you for tuning in to the MrExcel podcast. Don't forget to subscribe and I'll see you in the next episode!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

Table of Contents
(00:00) Autofill Section 1, Section 1.1
(00:23) Regular Fill will not work
(00:33) Easy to fill the numbers
(00:45) Adding word to number using custom number format
(00:59) But need to get rid of trailing zero
(01:14) Using 0.# in Custom Number Format fails
(01:35) Using 0.? also fails
(01:54) Conditional Format with MOD?
(02:17) Using "Section "General and it works!
(02:30) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #excelformatting #numberformatting #conditionalformatting 

This video answers these common search terms:
adding descriptions to numbers in excel
how to custom format a number in excel
how to do custom formatting in excel
creating custom number format with words
excel custom number format for adding words
text alongside numbers in excel custom format
excel custom number format decimals
excel number formatting with variable decimals
formatting decimal values in excel custom format
controlling decimal points in excel number format
how to do custom number format in excel
where is the custom format in excel
displaying labels with numbers in excel
excel number format with accompanying text
excel custom format with labels

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153590/

The General number format doesn't get a lot of love in Excel, but it does decide if a decimal point is needed in your numbers. As you had off into Custom Number formats, deciding if a decimal point is needed is somewhat dicey. Luckily, the General steps in to solve the problem in today's Learn Excel Podcast.

More from this channel