answersLogoWhite

0

In MS Excel 2010, there are 8 ways to format Time Cells

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

How do you convert Excel files to a different format?

It depends on the format you want. Excel can not be converted to every conceivable file type. However, you have many choices through the Excel "Save As" option.


How can you transfer your data from one Excel file to another file in another format?

You can convert an Excel file to many different formats. Just Save As and select the format you like.


What are the formats for displaying numbers in a cell?

There are many different formats for displaying numbers in an Excel cell including a general format, a currency format, a percentage format and an accounting format.


How can I convert PDF to excel for free?

Well, I would recommend converting PDF format files to excel format files with a PDF format file to excel format file converter. There are many PDF format file to excel format file converters offered for use.


How many decimals does the accounting format display in a cell in Excel?

The default is 2, but you can change the formatting to show a different amount of decimal places.


How many decimal digits can be used with the fixed or currency format?

In Excel, up to 30. In Excel, up to 30. In Excel, up to 30. In Excel, up to 30.


In Excel when a Sum formula is entered into a cell what is the format of the Sum cell?

There isn't one single format. It can be in different formats which will then determine what way the result will be displayed. So it can be in currency, percentage, date, time and many other formats.


Can you change the way data in table format is displayed?

This question is in many categories that may require different answers. In Excel you can use many formats to display your data and change whenever you like.


Which cell format display numerical data preceded by a dollar sign?

The currency and accounting formats can do that. As there are many currencies in the world, in different countries where the dollar is not used, a computer can be set to use a different currency symbol and it can also be done directly in Excel. So setting the cell format to currency or accounting format doesn't always put a dollar sign before the numbers.


If the format you need is not available in any of the predefined formats offered in excel you can create a general format?

You can create many types of custom formats. Just go to Format Cells | Number | Custom to create your custom format.


Is Excel and AN XML?

It is not XML, Excel is a spreadsheet software. But you could save your worksheet as XML format as well as other formats like XLS, CSV, and many more.


How do you format a cell to have a dollar sign appear immediately to the left of the first digit with no spaces?

Format the cell(s) as currency and ensure the currency is set to dollarsThe currency format can do that. As there are many currencies in the world, in different countries where the dollar is not used, a computer can be set to use a different currency symbol and it can also be done directly in Excel. So setting the cell format to currency format doesn't always put a dollar sign before the numbers.