Software Development Exam  >  Software Development Videos  >  Microsoft Excel 2013: Be the Excel Master  >  Microsoft Excel 2013 Tutorial - 4 - Formatting Numbers

Microsoft Excel 2013 Tutorial - 4 - Formatting Numbers Video Lecture | Microsoft Excel 2013: Be the Excel Master - Software Development

25 videos

FAQs on Microsoft Excel 2013 Tutorial - 4 - Formatting Numbers Video Lecture - Microsoft Excel 2013: Be the Excel Master - Software Development

1. How do I format numbers as currency in Microsoft Excel 2013?
Ans. To format numbers as currency in Microsoft Excel 2013, you can select the cells you want to format, then go to the "Home" tab, click on the "Number Format" dropdown menu, and select the "Currency" option. This will format the numbers with the default currency symbol and decimal places.
2. Can I customize the currency format in Excel 2013?
Ans. Yes, you can customize the currency format in Excel 2013. After selecting the cells you want to format, right-click and choose "Format Cells." In the Format Cells dialog box, go to the "Number" tab, select "Currency," and click on the "Customize" button. Here, you can modify the currency symbol, decimal places, and other formatting options to suit your needs.
3. How do I apply different number formats to different cells in Excel 2013?
Ans. To apply different number formats to different cells in Excel 2013, you can select the cells you want to format, right-click and choose "Format Cells." In the Format Cells dialog box, go to the "Number" tab, select the desired number format, and click on the "OK" button. This will apply the selected format to the selected cells only.
4. Is it possible to format numbers in Excel 2013 with thousands separators?
Ans. Yes, you can format numbers in Excel 2013 with thousands separators. After selecting the cells you want to format, right-click and choose "Format Cells." In the Format Cells dialog box, go to the "Number" tab, select "Number" or "Currency" as the category, and choose the desired number format with thousands separators. This will display the numbers with commas or dots as thousands separators.
5. Can I change the default number format in Excel 2013?
Ans. Yes, you can change the default number format in Excel 2013. Go to the "File" tab, click on "Options," and select the "Advanced" tab. Scroll down to the "Display" section and find the "Show this number of decimal places" option. Adjust the number of decimal places as desired, and click on the "OK" button. This will change the default number format for all new workbooks in Excel 2013.
Related Searches

Sample Paper

,

pdf

,

Objective type Questions

,

Previous Year Questions with Solutions

,

Semester Notes

,

mock tests for examination

,

video lectures

,

shortcuts and tricks

,

practice quizzes

,

Microsoft Excel 2013 Tutorial - 4 - Formatting Numbers Video Lecture | Microsoft Excel 2013: Be the Excel Master - Software Development

,

Extra Questions

,

Viva Questions

,

past year papers

,

study material

,

Microsoft Excel 2013 Tutorial - 4 - Formatting Numbers Video Lecture | Microsoft Excel 2013: Be the Excel Master - Software Development

,

Important questions

,

Summary

,

Exam

,

ppt

,

Microsoft Excel 2013 Tutorial - 4 - Formatting Numbers Video Lecture | Microsoft Excel 2013: Be the Excel Master - Software Development

,

Free

,

MCQs

;