Why do you use formatting in Excel?

Answer 1

For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.

For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.

For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.

For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.

For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.

For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.

For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.

For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.

For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.

For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.

For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.

Answer 2

Formatting numbers allows you to display them in different ways, such as in currency or in percentages, which are relevant to what you are doing. Formatting can also make numbers more meaningful or simpler to understand. You can also do things like have negative numbers appear in red to make them stand out.

Answer 3

For all sorts of reasons. Data is normally entered unformatted, but you want it in a particular way. So you may want a number to be shown as a percentage or as a currency format or with decimal places. To do that you need to format it. For other values such as dates, there are different ways you can display them. Text can be made into different sizes and colours. Times can have their format changed too. Cells can be changed, to be different colours or have borders around them for example. So there are many ways for things to be formatted and this needs to be done in Excel.