Question about Computers & Internet

1 Answer

I have numbers in this format 23.67- how do i

I have numbers in this format 23.67- how do i total these numbers with - at the end of number.

Posted by on

  • cubsms May 11, 2010

    What program are you using?


    Does the "-" character represent a negative number?

×

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 407 Answers

You will need to clean the "-" character at the end of the numbers - If all your number are in the same format with 6 characters simple clean or left function to remove the "-" once you have done that your new column should display all your numbers without the "-" you can either use this column in your sum function or create another column with "-" at the start so the digits are recognised as numbers and not text.

Posted on May 10, 2009

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:

2 Answers

What is formula to find percentage of females in my workplace?


      To get around this, you can calculate your numbers as percentages first. For example, if you type the formula =10/100 in cell A2, Excel will display the result as 0.1. If you then format that decimal as a percentage, the number will be displayed as 10%, as you 'd expect.Aug 2, 2011

      How to do percentages in Excel - Office Blogs

      https://blogs.office.com/2011/08/02/how-to-do-percentages-in-excel/
    Feedback

    How to Calculate Percentages in Excel

    www.excelfunctions.net > Excel-Formulas
    Two Percentage Calculation Types. Calculate a Percentage as a Proportion.Calculate Percentage Change. Displaying Percentages in Excel Cells ...

    Excel formula: Get percentage of total ' Exceljet

    https://exceljet.net/formula/get-percentage-of-total
    Excel simply divides the values in column C by the total in C11. For the formula shown, the result is the decimal number .63. Because the Percentage number format is applied to cell E6, Excel displays .63 as 63%.

Jan 19, 2016 | Computers & Internet

10 Answers

In Excel adding positive and negative numbers


Yes,


  1. Select the column. (click on top of the column it will select)
  2. Right Click and select Format Cells.
  3. Select Currency in Category then press OK
b6298df.gif Now just type your Numbers i.e. 571 for $571 and -650 for -$650 and sum using the normal way.

That is Select the Cells which you want to SUM and Press Alt+=

This will bring the total just below the selected cells.

Thanks
Iqbal

Apr 02, 2008 | Computers & Internet

1 Answer

Wants to give random page number in ms word


Not too sure whether your comment above is the problem or what you want to do.

Do you want to insert a page number, then put in non word doc pages, then have the next page in your word document numbered appropriately? If so, you need to insert a section break at the end of the page where you are going to put in pages, then make sure the page layout for the second section does not have "different first page" turned on. Now break any link between section 2 and section 1 in the page layout. So click off the "same as previous" icon in the footer in section 2. Then insert a new page number and set it to "start at" the page number you need it to be.

If you need several sections like this then just repeat the process.

Remember that if you delete a section break, then all the page formatting will revert to that in the previous section. Horrible but its what Word does. Go to the end of any document with sections and add one section break at the end of your text with the same page formatting as you want through the pages before you remove any section breaks in the document to avoid this.

There is a really good e-newsletter on Office issues, Woody's Office Watch; if you use Office a lot but find some features difficult to master, you'll love WOW, very helpful.

Sep 26, 2011 | Microsoft Office Professional 2007 Full...

1 Answer

The total snowfall in Buffalo, NY one year was inches. If the total snowfall the following year was inches, what was the percent change? Show and explain your solution.


I don't see any numbers in your question, so let's assume the number of inches in the first year is x and the number of inches in the second year is y. The percentage change is the difference between the number of inches in the second year and the number of inches in the first year, divided by the total number of inches in the first year. This number (which is a fraction) needs to be expressed as a percentage. Algebraically:
y-x is the difference between year 2 and year 1 (can be positive or negative)
x is the total number of inches in year 1
so:
(y-x)/x is the change fraction
(y-x)/x * 100 is the change percentage.

For example, if x = 50 and y = 40 then:
(40-50)/50 * 100 = (-10)/50 * 100 = (-.2) * 100 = -20% = a 20% reduction in snowfall in yr 2 over yr 1.

Feb 09, 2011 | The Learning Company Middle School...

1 Answer

Footer manual formatting


In Microsoft Excel, it is easier than in Word for formatting. On the Customise Footer page, use the A for formatting. Use the # for Page No and the double + for total no of pages. If you want the footer to show Page 3 of 5 Pages, this is what you have to do:
1) Type the word Page followed by a space,
2) Click on the # to display the correct page number,
3) Press the space bar and type the word "of"
4) Click on the double+ sign to insert the total number of pages
5) Press the space bar and type the word "pages"
In Word it is almost the same procedure.
Best of luck
luciana44

Aug 26, 2009 | Microsoft Office Professional 2007 Full...

2 Answers

FORMULA PROBLEM IN MS EXCEL


The cells you are trying to sum are probably text and not numeric values. Format them as number or convert them to numbers.

Apr 18, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

End of day


I have seen the same problem. Some just leave the amount what it says. I could never figure out what number that is.

Dec 05, 2008 | Pc America Restaurant Pro Express

1 Answer

Excel formula.....


Let's start with the 1st equation. I assume you want to be able to recalculate by changing the number of pages.

Put 65 in cell a1.
360 in b1
In C1, put the formula =a1/b1 that's your book thickness
In D1, put .02 for the cover
In E1, put the formula =C1+D1

Now you can change A1, B1,or D1 and the Total thickness gets recalculated automatically. Be careful not to type numbers into C1 or E1, or you lose the formula.

The same for the other equations - a cell for each number ("variable") and another cell for calculations.

Once you've verified the results, then you can get fancy and add titles above each field to make it easy to remember what goes where.

You may need to change the cell format to control the number of decimal places, or thousands commas. Right click on a cell and select format to see the choices you have.

Keep a backup copy of the spreadsheet in case someone (not you, of course) makes a mistake and overwrites the formula cells. You can also look into "protecting" cells to keep them from being changed.

Hope that helps.

Jul 14, 2008 | Computers & Internet

3 Answers

Formulas


meri excel file ka security paasward missing. Pls i want track the paasward.

Jul 13, 2008 | Microsoft Excel for PC

1 Answer

Excel functions


Here's one way to do it. Your formulas would look like this:

B1:
=IF(OR(J1=1, J2=1, J3=1, J4=1, J5=1),1,0)

B2:
=IF(OR(J1=2, J2=2, J3=2, J4=2, J5=2),2,0)

B3:
=IF(OR(J1=3, J2=3, J3=3, J4=3, J5=3),3,0)

etc.

If you don't want the zeroes to display, format the cells with a custom number format--type: 0;-0;;@

Nov 14, 2007 | Computers & Internet

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

Related Topics:

46 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

kakima

Level 3 Expert

98796 Answers

David Payne
David Payne

Level 3 Expert

14071 Answers

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

Answer questions

Manuals & User Guides

Loading...