answersLogoWhite

0


Best Answer

You can use the Formatting options to change the data type. It will depend what you want to change. Commonly numbers typed in show as dates, as the cell has been set to date type. Changing the formatting to number or currency or whatever you need will change it. Press Ctrl - 1 to quickly access the Format Cells dialog box.

User Avatar

Wiki User

9y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you change the data type in Excel if it is wrong?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Is character datatype of Excel?

The name used in Excel for that data type is Text, but it is like the character data type in other computer systems.


In Excel what bar is data displayed as you type?

The Formula Bar.


What is the characteristic that defines the kind of data that can be entered into a field such as numbers text or dates?

In Access, you use data type. In Word and Excel, you use data validation.


How do you keep data at the top of the page in Excel?

Type it in a cell at the top of the page or include the data in a header.


How do you enter data for Microsoft Excel?

Click on a cell and type in what you want to enter.


In Excel you can apply a chart type to an existing data series in a chart to create a?

different type of chart


How do you entered information into Excel worksheet?

You can just type in what you want into Excel, by putting things into cells. Then by entering formulas you can get information from the spreadsheet. You can get charts from your data. You can enter data using forms. You can enter data using form controls, such as drop-down boxes.You can just type in what you want into Excel, by putting things into cells. Then by entering formulas you can get information from the spreadsheet. You can get charts from your data. You can enter data using forms. You can enter data using form controls, such as drop-down boxes.You can just type in what you want into Excel, by putting things into cells. Then by entering formulas you can get information from the spreadsheet. You can get charts from your data. You can enter data using forms. You can enter data using form controls, such as drop-down boxes.You can just type in what you want into Excel, by putting things into cells. Then by entering formulas you can get information from the spreadsheet. You can get charts from your data. You can enter data using forms. You can enter data using form controls, such as drop-down boxes.You can just type in what you want into Excel, by putting things into cells. Then by entering formulas you can get information from the spreadsheet. You can get charts from your data. You can enter data using forms. You can enter data using form controls, such as drop-down boxes.You can just type in what you want into Excel, by putting things into cells. Then by entering formulas you can get information from the spreadsheet. You can get charts from your data. You can enter data using forms. You can enter data using form controls, such as drop-down boxes.You can just type in what you want into Excel, by putting things into cells. Then by entering formulas you can get information from the spreadsheet. You can get charts from your data. You can enter data using forms. You can enter data using form controls, such as drop-down boxes.You can just type in what you want into Excel, by putting things into cells. Then by entering formulas you can get information from the spreadsheet. You can get charts from your data. You can enter data using forms. You can enter data using form controls, such as drop-down boxes.You can just type in what you want into Excel, by putting things into cells. Then by entering formulas you can get information from the spreadsheet. You can get charts from your data. You can enter data using forms. You can enter data using form controls, such as drop-down boxes.You can just type in what you want into Excel, by putting things into cells. Then by entering formulas you can get information from the spreadsheet. You can get charts from your data. You can enter data using forms. You can enter data using form controls, such as drop-down boxes.You can just type in what you want into Excel, by putting things into cells. Then by entering formulas you can get information from the spreadsheet. You can get charts from your data. You can enter data using forms. You can enter data using form controls, such as drop-down boxes.


Is the menu bar always the same regardless of the type of work being done in Excel?

No. It can sometimes change. For example, the Data menu is replaced by the Chart menu when a chart is selected.


Can Excel recognize the following text 401AX21?

There is no reason why you cannot type that in. As there are letters in it, it will be treated by Excel as text.


What is a link in Excel?

A link in Excel can be like a link on a webpage. By clicking on it, it can enable you to jump to different parts of the worksheet, different parts of the workbook, to a different workbook, to another kind of file and to a webpage. Another type of link is where data in one workbook is linked to data in another workbook or other kind of document. When data is updated in one, it will also change in the other document, as it is looking at data it is linked to.


What should the Save As file type be if saving Excel?

That will depend on what you want to do. If you are in Excel saving as a standard Excel file, you don't need to change the file type. It is only if you want to save into a different format, that you would change the File Type. What you change it to, would depend on what you need. You might want to change to a different version of Excel or maybe into a completely different format, such as a text file. If you are working in a different application, saving something to be used in Excel, then again it will depend on what format you actually need.


When you type numeric data in a cell Excel automatically positions the entry in the cell?

Right-aligned