0
How do you stop the zero at the start of a phone number being deleted in a Excel spreadsheet?
Wiki User
∙ 15y ago
If it's just a phone number it will never be used in calculations so you need to format the cells as Text. Either select the entire column or row that is going to contain the phone numbers before you enter anything and format it as text - Format... Cells menu or type an apostrophe (') before each phone number as you type it.
Please note that, while this is a good system for phone numbers, it is a very bad system for any numbers that may be used in calculations because they are no longer numbers, but text strings. If you need to have leading zeroes before any number you will have to use the "Format Cells" option. In the "Number" tab go to the "Custom" option (It is usually the last on the list). Type "0## #### ####" OR whatever numbers you require. In the above format, if you enter the number 1234567890, it will display as "012 3456 7890". (You can use the data as numbers if you want to also)
Wiki User
∙ 15y ago
Add your answer:
Earn +20 pts
Why compile Excel spreadsheets?
To prevent anyone from seeing or changing formulas, as well as being able to use the spreadsheet without needing Excel. A compiler can collect all source files for the spreadsheet, add a run-time engine, and package the files for distribution.
Is a excel hardware or software?
Originally a spreadsheet was on paper. Now we normally think of a spreadsheet as being a piece of software, such as Microsoft Excel.
Write an essay on Microsoft Excel?
Microsoft excel is a spreadsheet program developed by Microsoft corporation. There are different version of Microsoft excel with the latest being Microsoft excel 2010 which is boundled with Microsoft office 2010. Microsoft excel contains basic features of which all the spreadsheet programs have. It has worksheets which are a grid of cells. The grid of cell is arranged in rows and columns with the rows being referred to with numbers and rows with alphabetical letters. Microsoft excel has many wonderful features to offer the small business user. Excel is mosyt widely known for its spreadsheet function, though it has numerous other uses. Spreadsheets are useful to any type of small business. For example, spreadsheet can be used as an accountant's ledger or a professor's grade book. Invoices and budgets can be prepaired with excel and one might use it to balance a checkbook as well.
Why does multiplication come before addition in Excel?
Excel, being spreadsheet, follows the laws of mathematics. One of those laws is that multiplication comes before addition. It is part of the order of precedence of operations. See the related question below.
How do you add page numbering to Excel spreadsheets?
You can do it through the Page Setup when a spreadsheet is being prepared to be printed. Go to the File menu and then Page Setup. You can the set a custom header or footer and insert things like the date, the name of the worksheet and the page number. They will then appear on pages you print. They don't show in the spreadsheet itself as it is made of worksheets and not pages.
What category of software does Excel belong to?
It could be categorised as applications software. Being more specific it could then be categorised as spreadsheet software.It could be categorised as applications software. Being more specific it could then be categorised as spreadsheet software.It could be categorised as applications software. Being more specific it could then be categorised as spreadsheet software.It could be categorised as applications software. Being more specific it could then be categorised as spreadsheet software.It could be categorised as applications software. Being more specific it could then be categorised as spreadsheet software.It could be categorised as applications software. Being more specific it could then be categorised as spreadsheet software.It could be categorised as applications software. Being more specific it could then be categorised as spreadsheet software.It could be categorised as applications software. Being more specific it could then be categorised as spreadsheet software.It could be categorised as applications software. Being more specific it could then be categorised as spreadsheet software.It could be categorised as applications software. Being more specific it could then be categorised as spreadsheet software.It could be categorised as applications software. Being more specific it could then be categorised as spreadsheet software.
How do you convert Ms-word to Excel?
You cannot convert from Microsoft Word to Microsoft Excel as such. They are two different kinds of applications, one being a word processor and the other being a spreadsheet. You can copy and paste things from one to the other. Usually this would be things in tables, as a spreadsheet is based on tables and a word processor has the capability of dealing with tables. It is also possible to link them, doing a copy and instead of pasting, doing a paste link.You cannot convert from Microsoft Word to Microsoft Excel as such. They are two different kinds of applications, one being a word processor and the other being a spreadsheet. You can copy and paste things from one to the other. Usually this would be things in tables, as a spreadsheet is based on tables and a word processor has the capability of dealing with tables. It is also possible to link them, doing a copy and instead of pasting, doing a paste link.You cannot convert from Microsoft Word to Microsoft Excel as such. They are two different kinds of applications, one being a word processor and the other being a spreadsheet. You can copy and paste things from one to the other. Usually this would be things in tables, as a spreadsheet is based on tables and a word processor has the capability of dealing with tables. It is also possible to link them, doing a copy and instead of pasting, doing a paste link.You cannot convert from Microsoft Word to Microsoft Excel as such. They are two different kinds of applications, one being a word processor and the other being a spreadsheet. You can copy and paste things from one to the other. Usually this would be things in tables, as a spreadsheet is based on tables and a word processor has the capability of dealing with tables. It is also possible to link them, doing a copy and instead of pasting, doing a paste link.You cannot convert from Microsoft Word to Microsoft Excel as such. They are two different kinds of applications, one being a word processor and the other being a spreadsheet. You can copy and paste things from one to the other. Usually this would be things in tables, as a spreadsheet is based on tables and a word processor has the capability of dealing with tables. It is also possible to link them, doing a copy and instead of pasting, doing a paste link.You cannot convert from Microsoft Word to Microsoft Excel as such. They are two different kinds of applications, one being a word processor and the other being a spreadsheet. You can copy and paste things from one to the other. Usually this would be things in tables, as a spreadsheet is based on tables and a word processor has the capability of dealing with tables. It is also possible to link them, doing a copy and instead of pasting, doing a paste link.You cannot convert from Microsoft Word to Microsoft Excel as such. They are two different kinds of applications, one being a word processor and the other being a spreadsheet. You can copy and paste things from one to the other. Usually this would be things in tables, as a spreadsheet is based on tables and a word processor has the capability of dealing with tables. It is also possible to link them, doing a copy and instead of pasting, doing a paste link.You cannot convert from Microsoft Word to Microsoft Excel as such. They are two different kinds of applications, one being a word processor and the other being a spreadsheet. You can copy and paste things from one to the other. Usually this would be things in tables, as a spreadsheet is based on tables and a word processor has the capability of dealing with tables. It is also possible to link them, doing a copy and instead of pasting, doing a paste link.You cannot convert from Microsoft Word to Microsoft Excel as such. They are two different kinds of applications, one being a word processor and the other being a spreadsheet. You can copy and paste things from one to the other. Usually this would be things in tables, as a spreadsheet is based on tables and a word processor has the capability of dealing with tables. It is also possible to link them, doing a copy and instead of pasting, doing a paste link.You cannot convert from Microsoft Word to Microsoft Excel as such. They are two different kinds of applications, one being a word processor and the other being a spreadsheet. You can copy and paste things from one to the other. Usually this would be things in tables, as a spreadsheet is based on tables and a word processor has the capability of dealing with tables. It is also possible to link them, doing a copy and instead of pasting, doing a paste link.You cannot convert from Microsoft Word to Microsoft Excel as such. They are two different kinds of applications, one being a word processor and the other being a spreadsheet. You can copy and paste things from one to the other. Usually this would be things in tables, as a spreadsheet is based on tables and a word processor has the capability of dealing with tables. It is also possible to link them, doing a copy and instead of pasting, doing a paste link.
What is the Quote mark in an excel spreadsheet?
The quote mark can be used to change data into text format. If you want to do something like show a number starting with a zero or display a formula, you can put the sing quote before them. It would prevent the zero being ignored or a formula being calculated:'01'=A1+A3
How do you protect a workbook getting deleted?
You cannot protect it from being deleted as such. Any file on a computer can be deleted. The thing to do is to have a backup copy, so if it does get deleted, you have a spare copy.You cannot protect it from being deleted as such. Any file on a computer can be deleted. The thing to do is to have a backup copy, so if it does get deleted, you have a spare copy.You cannot protect it from being deleted as such. Any file on a computer can be deleted. The thing to do is to have a backup copy, so if it does get deleted, you have a spare copy.You cannot protect it from being deleted as such. Any file on a computer can be deleted. The thing to do is to have a backup copy, so if it does get deleted, you have a spare copy.You cannot protect it from being deleted as such. Any file on a computer can be deleted. The thing to do is to have a backup copy, so if it does get deleted, you have a spare copy.You cannot protect it from being deleted as such. Any file on a computer can be deleted. The thing to do is to have a backup copy, so if it does get deleted, you have a spare copy.You cannot protect it from being deleted as such. Any file on a computer can be deleted. The thing to do is to have a backup copy, so if it does get deleted, you have a spare copy.You cannot protect it from being deleted as such. Any file on a computer can be deleted. The thing to do is to have a backup copy, so if it does get deleted, you have a spare copy.You cannot protect it from being deleted as such. Any file on a computer can be deleted. The thing to do is to have a backup copy, so if it does get deleted, you have a spare copy.You cannot protect it from being deleted as such. Any file on a computer can be deleted. The thing to do is to have a backup copy, so if it does get deleted, you have a spare copy.You cannot protect it from being deleted as such. Any file on a computer can be deleted. The thing to do is to have a backup copy, so if it does get deleted, you have a spare copy.
Differences between ms-word and ms-Excel?
Vista is an operating system. Excel is a spreadsheet. Vista would be classed as Systems software and Excel as Applications software. An operating system is responsible for the proper working of the computer. Without an operating system, you cannot use your computer. Applications software is software designed to do particular kinds of work, Excel being designed to be a spreadsheet. It needs an operating system to work on. It interacts with the operating system in order for it to work. So the operating system will do things like provide the memory space it needs to run or facilitate the saving of a document or help print it, amongst many other things.
What happens when you change a value in Excel on which a chart is dependent?
It will immediately redraw the chart based on the new value
What is a column header in Excel?
Headers and footers are lines of text that print at the top (header) and bottom (footer) of each page of a spreadsheet. They contain descriptive text such as titles, dates, and/or page numbers. They are used to add information to a spreadsheet that is being printed. Information about how to use headers and footers in Excel is included in the related links.
