Question about Computers & Internet

Ad

Use Edit, Column or row, and format cell. then select type of number, integer or number of decimal places etc.

Nov 03, 2016 | The Computers & Internet

On the home toolbar, there is a section titled "Number". That would be where you would change the format to whatever you want it to. Even Red..

So, all you have to do is enter in the number you want and Excel puts in the decimal point, or the dollar sign, or the percent sign for you. And you can even change the amount of decimal places you want it to go as well..

Highlight the cells/numbers you want to format, then go to the number section on the toolbar (edit), and select the format that you want.

So, all you have to do is enter in the number you want and Excel puts in the decimal point, or the dollar sign, or the percent sign for you. And you can even change the amount of decimal places you want it to go as well..

Highlight the cells/numbers you want to format, then go to the number section on the toolbar (edit), and select the format that you want.

May 15, 2014 | Microsoft Corporation Microsoft EXCEL 97...

if the problem is in Excel then you have to configure decimal place for your cells. you can do that from menu

format/cell/number (decimal place=2)

if anywhere else please write down which software.

vote me if found helpful.

format/cell/number (decimal place=2)

if anywhere else please write down which software.

vote me if found helpful.

Aug 04, 2011 | Computers & Internet

The selector you are asking about is the "decimal selector". The result displayed/printed, will be in a format according to the position that you have selected as follows:

f = floating (the result will be in the number of decimal places that were entered on the keyboard

4= fixed 4 decimal places (x.0000)

3= fixed 3 decimal places (x.000)

2= fixed 2 decimal places (x.00)

0= fixed 0 decimal places (x)

add 2= (add mode*,fixed 2 places) ($.00)

Note* "ad mode" automatically enters the decimal place when entering the number on the keyboard. If you enter "123", the displayed ammount will be "1.23". If you enter "1", the display will read ".01". This is a useful setting when adding a list of numbers in a dollars/cents format, however, be careful, if entering a whole dollar ammount "three dollars" be sure to enter the decimal point, or enter the number as "300". If you don't, the result will be ".03", instead of the 3 dollars you intended.

f = floating (the result will be in the number of decimal places that were entered on the keyboard

4= fixed 4 decimal places (x.0000)

3= fixed 3 decimal places (x.000)

2= fixed 2 decimal places (x.00)

0= fixed 0 decimal places (x)

add 2= (add mode*,fixed 2 places) ($.00)

Note* "ad mode" automatically enters the decimal place when entering the number on the keyboard. If you enter "123", the displayed ammount will be "1.23". If you enter "1", the display will read ".01". This is a useful setting when adding a list of numbers in a dollars/cents format, however, be careful, if entering a whole dollar ammount "three dollars" be sure to enter the decimal point, or enter the number as "300". If you don't, the result will be ".03", instead of the 3 dollars you intended.

May 20, 2011 | Royal 29307U Calculator

- Right click on the the letter at the top of the column you are entering the larger numbers in and choose "format cells" from the drop down menu.
- Then click on "number" and this is where you can set the number of decimal places or other adjustments.

Robert

Feb 25, 2011 | Microsoft EXCEL 2004 for Mac

The function is called ROUND. It has 2 arguments, (1) the original number and (2) the number of decimal digits. Here is the Excel's help:
ROUND(number,num_digits)
The number you want to round.
• None.
num_digits The number of digits to which you want to round number.
• If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places.
• If num_digits is 0, then number is rounded to the nearest integer.
• If num_digits is less than 0, then number is rounded to the left of the decimal point.

So for your case use this in a cell "=ROUND(12350*32.75%, 0)" without quotes, where I assume one or both numbers will come from other cells. -Ken

So for your case use this in a cell "=ROUND(12350*32.75%, 0)" without quotes, where I assume one or both numbers will come from other cells. -Ken

Aug 29, 2009 | Microsoft Office Excel 2007

could you please supply us with the version of Excel you are using? it's under Help About Excel

Mar 04, 2008 | Excel (SS8SATAS5128400R)

Just follow the steps....

- Type "Enter Land in Gundas" in A1
- Type "Equivalent Land in Acres" A2
- Type "=B1/40"
- Now type the number of gundas in B1 example 100
- you will automatically get 2.5 in B2

- Select B2 Cell
- Right Click and goto Format Cell
- Goto Number
- Under Number select Number Catogory
- and then select 2 decimals

Jan 31, 2008 | Computers & Internet

Dear Friend,

Try right clicking the selected cell, then choose the "format cells" option. Under the tab labeled number, you can choose many different options for how you want your number displayed. The "General" option will cause it to be just plain numbering with no decimals. Let me know if this helps, if not I still have more ideas which may help.

Arthur B

Try right clicking the selected cell, then choose the "format cells" option. Under the tab labeled number, you can choose many different options for how you want your number displayed. The "General" option will cause it to be just plain numbering with no decimals. Let me know if this helps, if not I still have more ideas which may help.

Arthur B

Jan 12, 2008 | Computers & Internet

Jul 03, 2020 | The Computers & Internet

Jul 02, 2020 | GTech Computers & Internet

59 people viewed this question

Usually answered in minutes!

×