0
Excel STILL does not have a specific significant figures function and will only accept 15 significant figures when entering numbers.
Quite simply you have to write your own formula and have to do workarounds when entering longer numbers.
Mike Hall
Wiki User
∙ 14y agoTo set the amount of decimal places you want to show, select your figures, go to the format men, pick Cells, pick Number and then you choose the amount of decimal places.
Add your answer:
Earn +20 pts
How does Microsoft Excel helps in accounting?
It can calculate numbers and set out tables and graphs
What programs does Microsoft have for document management?
Microsoft has a whole set of document management programs. This set is called Microsoft Office which includes; excel, power point, office point, word, and publisher.
What option cannot be set in the page setup dialog box in Microsoft Excel?
orientation
In Microsoft Excel what is the meaning of Data Validity?
In Excel, you can set validation rules on a cell to ensure the data meets specified conditions before Excel will accept the entry.
Does Microsoft Excel find gross pay?
Yes, Microsoft Excel can be used to find gross pay. You would need to set up the necessary formulas to do so, but it can be done. There are many payment system used around the world, so there is not a definitive set of formulas that can always be used.
What is a radio on Microsoft Excel?
A radio button is a form control. It is usually part of a set where one can selected but no others. You can link them to cells to set values for them.
What name did Excel have before Excel?
The very spreadsheet program was called VisiCalc in 1979. Other significant ones followed, most notably Lotus 1-2-3. These were made by various different companies. Microsoft orignally created a spreadsheet called Multiplan in 1982. It was not very successful. So they set about creating a completely new product, and that was called Excel. It was launched in 1985 and has always been known as Excel.
How do you change password on Microsoft office 2007 excel file?
Passwords can be set and changed from the Tools and then Options menu when saving a file.
What is scenario in Microsoft Excel?
a scenrious ia a set of values , which are saved by excel , and later substituted automatically in your worksheet . it s used when you are not sure of the outcome , so you can forecast the outcome of worksheet model.
What is Microsoft's product called 'Project Planner' used for?
Microsoft's product "Project Planner" is used to set up various graphs and table charts for jobs, school, and for presentations. It is an extension to Microsoft's famous software call Excel.
How do you run VB in Microsoft Excel?
You can do it by creating macros and then editing the macros. The macros or set of code can be applied to a button. It will depend on the version of Excel you have, but you can usually start creating macros or writing code through the Tools menu.
Are Microsoft Word Microsoft Excel and Microsoft Access interchangeable?
Each primarily have their own purposes: Word for Word Processing, Excel for Spreadsheets and Access for Databases. Whichever of those 3 things you want to do will determine which application is best for the job. However, in each case a lot of what you would do with the primary application can be done in the secondary ones, though not as efficiently. For example it is possible to do formulas similar to Excel in Word. It is possible to do a lot of database activities in Excel. It is also possible to do things in one application and bring them into another. A table of data in Excel can be copied and pasted into Word, becoming a Word table, or save and exported so that it can be imported into Access and become a data table. You can also set up links between different documents. So you could link a Word document to figures in an Excel document, so that when the Word document is opened, it will show the up to date figures in the Excel document. These are just a few examples of what you can do. There are many others. Sometimes that interchangeability is necessary, as it is more efficient to do some of the work in the appropriate application and then bring it into one of the others. Of the 3, Excel is probably the most flexible of them and has the widest range of things it can do that can be done in the others, and Word would be the most limited.
