How to set numbers to uppercase in Microsoft Excel-How to set numbers to uppercase

Time: 2021-11-09Source: Huajun Software TutorialAuthor: Ai Xiaomo

Friends, do you know how to set numbers to uppercase in Microsoft Excel? So today I will explain how to set numbers to uppercase in Microsoft Excel. How to set numbers to uppercase in Excel. If you are interested, please come and take a look with me. I hope it can help you.

Step 1: First, we select the cells that need to be set to uppercase numbers (as shown in the picture).

Step 2: Then select the "Cell" option under "Format" (as shown in the picture).

Step 3: Finally, select "Special" - "Chinese Capital Numbers" under the "Number" option, and click OK after selecting (as shown in the picture).

Step 4: At this time, all lowercase numbers will become uppercase (as shown in the picture).

The above is the entire content of how to set numbers to uppercase in Microsoft Excel that the editor has brought to you. I hope it can help you.

Related articles更多>>

• How to insert a three-dimensional column chart in Microsoft Excel 2019-How to insert a three-dimensional column chart
• How to zoom the selected area in Microsoft Excel 2019-Methods to zoom the selected area
• How to turn off the auto-save feature in Microsoft Excel 2019 - Methods to turn off the auto-save feature
• How to enter square 2 in Microsoft Excel 2019-How to enter square 2
• How to delete blank rows or cells in Microsoft Excel 2019 - Methods to delete blank rows or cells
• How to quickly delete duplicate values ​​in Microsoft Excel 2019 - Methods to delete duplicate values
• How to Create a Sparkline Chart in Microsoft Excel 2019 - Methods to Create a Sparkline Chart
• How to insert special symbols in Microsoft Excel 2019 - Methods to insert special symbols
• How to use advanced filtering in Microsoft Excel 2019 - Methods of using advanced filtering
• How to hide a worksheet in Microsoft Excel 2019-How to hide a worksheet

Popular recommendations

• 

  DingTalk Smart Cloud Printing Tool

  Version: latest versionSize: 33.5 MB

  The latest version of DingTalk Smart Cloud Printing Tool is a file printing sharing plug-in tool specially built for DingTalk. The official version of DingTalk Smart Cloud Printing Tool can help...

• 

  ZenTao Project Management Software Enterprise Edition

  Version: v8.8 latest versionSize: 264.3MB

  Based on the functions of ZenTao Professional Edition, ZenTao Enterprise Edition adds operation and maintenance management, OA office management, feedback management and document version management, online preview...

• 

  Word 2020

  Version: v4.3.5.2 official versionSize: 11MB

  Word2020 official version is a very excellent document editing and processing software in the Microsoftoffice2020 office software collection. Word2020 official version...

• 

  Word 2016

  Version: v4.3.5.10 free latest versionSize: 4.6MB

  6WordWord2016 reading WordWord2016 installation package will be downloaded through Microsoft's official authorized product assistant (software size: 4.62MB), please feel free to use it...

• 

  Microsoft Office Word2021

  Version: 4.3.5.10Size: 5.69MB

  Microsoft Office Word 2021 official version is a fully functional document editing tool. MicrosoftOffice The latest version of Word2021 supports w...