# whole number

1. ### Whole Numbers

In my use of formulas when calculating numbers from a live data feed. Negative numbers are important, however I am looking for a method to remove the polarity of a number and have it represented as a whole positive number regardless if it was previously negative? Can some one help? Thanks
2. ### sum of only whole numbers in a column.

I am using Numbers on my Mac. I want to add a range of all cells, but not include any negative values. I was thinking sumifs, but not sure how it works, or if that is the way to do it. please help. Sorry, I know this is simple. I did a quick search, but didn’t find anything.
3. ### Counting using raitios and combining Remainders

I love excel and use it for all my business needs ive recently made a very large workbook with many calculations and they all work the way i want. save for one section! i for the life of me cannot get this to calculate correctly. please help me! here is what i am attempting i need to count...
4. ### Extracting Minutes from Time

Hi all I have a cell (say A1) that contains data (in HH:MM) format. What I would like to do in the next cell (A2) I would like to extract the minute part of A1 but have it in a normal number format so for eg 01:41 would just show as 41 in cell A2. I can do it by just changing the number...
5. ### Applying Comma style, but having whole numbers have zero decimal points

I'm trying to figure out how to format a group of cells where comma style is applied, but if the number is whole it has zero decimal places. I don't understand the excel code very well I don't know how to do this off the top of my head. I'm sure it's very easy, but any help is greatly appreciated!
6. ### Solver Scenario for Optimal Whole Number w/Office97

Every time I think I know what I'm doing with Excel Solver - I surprise myself (by what I apparently don't understand . . .). I'm trying to solve for the maximum number of company store "certificates" I need to buy, up to say a maximum of \$600, in order to buy the maximum number of movie...
7. ### Mathematical problem-ROUND function doesn't help

I have an annual sales target of no. of units to be sold which is to be divided quarterly. My historical sales data gives me the ratios in which the annual target is to be divided into quarters, the ratios are 0.17, 0.23, 0.3 and 0.3 respectively for Q1,Q2,Q3 and Q4. When I divide the target...
8. ### Assigning dollar amounts to numbers for inventory

Hello all, I am creating an inventory sheet and am stuck on the waste category. It is obviously easier to count the waste as whole units, but I would like to assign dollar amounts to each unit in each cell, individually. For instance, for hamburger buns(\$.33) lost, arbitrarily I would put 40...
9. ### Removing whole number to leave decimal

Is there a way that I can remove the whole number to leave the decimal place. 1.69 should be 0.69 10.71 should be 0.71 0.48 should be 0.48

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back