Hello,

I would like to know how to round off an number in microsoft 2007 excel

Example question: select and insert the worksheet function that will round off a number (either rounding up or down) to a specified number of digits.

Thanks,

FPH

Check the standard tool bar, increase decimal places/decrease decimal places tool will solve your problem.

Posted on Nov 04, 2008

Hi,

a 6ya expert can help you resolve that issue over the phone in a minute or two.

best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).

click here to download the app (for users in the US for now) and get all the help you need.

goodluck!

Posted on Jan 02, 2017

Creating a table in Microsoft Excel 2007 allows you to work with that data independently of the rest of the worksheet. First you must define your table, though, which you can do either from scratch or from data already in the worksheet. The process is a simple one. Read on to learn how to define a table in Excel 2007
Thanks for choosing Fixya............
Sandeep

Start off by doing one of the following: Select the range of cells that you want to make into a table within your worksheet then proceed to Step 2 OR Start immediately with Step 2.

Click on the "Insert" tab at the top of the document.

Find the "Tables" group, then click on "Table." The "Create Table" dialog box will appear.

Type in a range for your table if you did not select a range in Step 1. If you did already select a range then that range will automatically appear in the dialog box.

Check the "My Table Has Headers" box if the data set you selected already contains the headers you want to use. If you don't check this box, the table will display default header names, which you can then go in and change.

Hit the "OK" button at the bottom of the Create Table dialog box to create your table.

Mar 18, 2011 | Computers & Internet

Hello everybody, this would be my first tip on FixYa.com.
Number of people might not be aware how many rows and columns are there in Microsoft Worksheet.

This is how you can find out.

1. Select A1 cell in the worksheet

2. Now press Ctrl + down arrow from your keyboard, that will take you to the bottom of the row. You can find the number on the left side.

3. Again select A1 cell in the worksheet and press Ctrl + left arrow from your keyboard, that will take you to the last column of the worksheet. Now to number, just type "=column() " , without quotations, that will give you the number of the column.

Microsoft Worksheet columns is number from A to Z, again from AA to AZ, again from BA to BZ and so on till it reached IV in Excell 2003 and earlier version.

Microsoft Excel 2003 and old version has 16,777,216 cells per worksheet (65,536 rows * 256 columns).

Excel 2007 has 17,179,869,184 cells per worksheet (1,048,576 rows * 16,384 columns).

This is how you can find out.

1. Select A1 cell in the worksheet

2. Now press Ctrl + down arrow from your keyboard, that will take you to the bottom of the row. You can find the number on the left side.

3. Again select A1 cell in the worksheet and press Ctrl + left arrow from your keyboard, that will take you to the last column of the worksheet. Now to number, just type "=column() " , without quotations, that will give you the number of the column.

Microsoft Worksheet columns is number from A to Z, again from AA to AZ, again from BA to BZ and so on till it reached IV in Excell 2003 and earlier version.

Microsoft Excel 2003 and old version has 16,777,216 cells per worksheet (65,536 rows * 256 columns).

Excel 2007 has 17,179,869,184 cells per worksheet (1,048,576 rows * 16,384 columns).

on Jul 27, 2010 | Microsoft Excel for PC

Parts of the Excel 2007 Screen

Here are the main parts of Microsoft Excel 2007. Thank you for using Fixya !!!

Nov 15, 2010 | Microsoft Windows XP Professional

In Excel Worksheet 2007 the maximum number of rows per worksheet is 1,048,576 and the no. of cols. is 16,384 which is col. XFD, which makes it 17,179,869,184 cells.

Jul 26, 2010 | Microsoft Windows Vista Ultimate Edition

Use the Math.Round() function. It takes two arguments, the first is your number or a variable holding your number and the second is the number of decimal places. This will only round to fractions of a whole number though and you need to round to the nearest 10. So divide your number by 10 before you round to shift the decimal place once to the left and multiply by 10 again afterwards to shift it back again.

answer = Math.Round(32.1 / 10, 0) * 10

answer = Math.Round(32.1 / 10, 0) * 10

Apr 02, 2009 | Microsoft Visual Basic 6.0 for PC

go to Insert > File >select file and insert.

you have to select all documents when you when insert box opens.

you have to select all documents when you when insert box opens.

Mar 15, 2009 | Microsoft Excel for PC

You can use some add in for Excell, can be found much of them on internet. Or follow this instruction: http://www.cpearson.com/excel/Duplicates.aspx for any brainstorming :)

Mar 11, 2009 | Microsoft Computers & Internet

is it helpful or not plz reply me and ask me syntax i m intersted in solving problem like this bcoz through it i get refreshed in C languge.

u can send me a query on my email akhilgnit @gmail.com

thnx

u can send me a query on my email akhilgnit @gmail.com

thnx

Feb 07, 2009 | Microsoft Visual Basic 6.0 for PC

format the cells that contains times and net time worked as time format you using
Enter the simple formula =if(c14<=0,Int(0),(c14-c13))

Feb 04, 2009 | Microsoft Excel for PC

- Click the
**Microsoft Office Button**, click**Excel Options**, and then click the**Formulas**category. - In the
**Calculation options**section, select the**Enable iterative calculation**check box. - To set the maximum number of times that Excel will recalculate, type the number of iterations in the
**Maximum Iterations**box. The higher the number of iterations, the more time that Excel needs to calculate a worksheet. - To set the maximum amount of change you will accept between calculation results, type the amount in the
**Maximum Change**box. The smaller the number, the more accurate the result and the more time that Excel needs to calculate a worksheet.

Nov 05, 2008 | Microsoft Excel for PC

421 people viewed this question

Usually answered in minutes!

×