Question about Computers & Internet

1 Answer

Excel on entering a number to a cell the number is automatically given to decimal places. it happens anywhere on he sheet. Ive tried a number of fixes wth no sucess help I believe the problem is elsewhere

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 73 Answers

Select the cell or group of cells --> Format --> Cells

Posted on Oct 30, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

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

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

My excel worksheet - for a whole number you have to enter 1. or 9. or 10. How can I avoid the . and still get a whole number


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

1 Answer

How do I fix how my percentage shows on the excel spreadsheet?


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.

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

1 Answer

Rounding numbers to the nearest ten99 9236


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.

Aug 04, 2011 | Computers & Internet

1 Answer

What is the default setting for the f cut 5/4 and the 4320 add 2 I don't know what to have these options set at thanks EW Seattle


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.

May 20, 2011 | Royal 29307U Calculator

3 Answers

How to round the fig. in Excel 2007 E.g. 12350*32.75% = 4044.625 I want it to be rounded to nearer rupee. If the decimal is lesser than 50, rounded fig. should be lower Rupee if the decimal is more than 50...


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

Aug 29, 2009 | Microsoft Office Excel 2007

6 Answers

EXCEL FORMULA NOT WORKING


No tmaking promises but try pushing F9 and for future make sure the Automatic caluculation is turned on.
ace3905.gif

Nov 26, 2008 | Microsoft Excel for PC

3 Answers

Excel password removing


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

Mar 04, 2008 | Excel (SS8SATAS5128400R)

1 Answer

Land measuring


Just follow the steps....
  1. Type "Enter Land in Gundas" in A1
  2. Type "Equivalent Land in Acres" A2
  3. Type "=B1/40"
  4. Now type the number of gundas in B1 example 100
  5. you will automatically get 2.5 in B2
Now you need only two decimals tighy?
  1. Select B2 Cell
  2. Right Click and goto Format Cell
  3. Goto Number
  4. Under Number select Number Catogory
  5. and then select 2 decimals
Thats all

Jan 31, 2008 | Computers & Internet

1 Answer

Excel is adding a decimal point


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

Jan 12, 2008 | Computers & Internet

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

56 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18386 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...