Excel - AutoFill Section 1, Section 1.1 Using Custom Number Formatting for General - Episode 1769
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.
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.