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:

1 Answer

How many days from 01/11/1944 to 01/07/2016


Date difference from Jan 11, 1944 to Jan 7, 2016 The total number of days between Tuesday, January 11th, 1944 and Thursday, January 7th, 2016 is 26,294 days.
This is equal to 71 years, 11 months, and 27 days.
This does not include the end date, so it's accurate if you're measuring your age in days, or the total days between the start and end date. But if you want the duration of an event that includes both the starting date and the ending date, then it would actually be 26,295 days.
If you're counting workdays or weekends, there are 18,782 weekdays and 7,512 weekend days.
If you include the end date of Jan 7, 2016 which is a Thursday, then there would be 18,783 weekdays and 7,512 weekend days including both the starting Tuesday and the ending Thursday.
26,294 days is equal to 3,756 weeks and 2 days.
The total time span from 1944-01-11 to 2016-01-07 is 631,056 hours.
This is equivalent to 37,863,360 minutes.
You can also convert 26,294 days to 2,271,801,600 seconds.


Number of days between January 11th 1944 and January 7th 2016

Jan 10, 2017 | Watches

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

1 Answer

HP 12 C display does not show entire numbers. How do I fix?


If you mean it is not showing everything after the decimal point, you can change that by pressing the [f] key followed by the number of decimal places to display. For example, to restrict it to 2 places, press [f][2]. If you want to see 4 places, press [f][4].

To show all possible decimal places, use the sequence [f][9].
From the manual (http://www.hp.com/ctg/Manual/c00363319.pdf):
"To display a different number of decimal places, press f followed by a digit key (0 through 9) specifying the number of decimal places. In the following examples, notice how the displayed form of the number inside the calculator - 14.87456320 - is rounded to the specified number of digits."


25096057-rvrejqbjq4zuw4cbinsyjvsy-5-0.png "Although nine decimal places were
specified after f, only eight are
displayed since the display can
show a total of only 10 digits. "
The standard display format, plus the specified number of decimal places, remain in effect until you change them; they are not reset each time the calculator is turned on. However, if Continuous Memory is reset, when the calculator is next turned on numbers will be displayed in the standard display format with two decimal places
shown.
If a calculated answer is either too small or too large to be displayed in the standard display format, the display format automatically switches to scientific notation. The display returns to the standard display format for all numbers that can be displayed in that format.
http://www.hp.com/ctg/Manual/c00363319.pdf

Sep 12, 2014 | HP 12c Calculator

1 Answer

When I key the numbers and then total them up this is what I get at the end of the total 1276.33--64G*and the decimal don't aline. help


Could it be that you misunderstand the meaning of the decimals that are not aligned? On some calculators the exponent for the power of 10 in scientific notation is displayed almost on the same line as the rest of the mantissa.

Apr 11, 2012 | Texas Instruments Office Equipment &...

2 Answers

9999555533331111 select any 6 number whose total only addition is 21


5 + 5 + 5 + 5 + 1 = 21

That's a 5-number solution and that -I'm afraid- is the closest you're going to get.  The numbers are all odd numbers.  Add ANY 6 odd numbers together and you'll end up with an even number.  21 is an odd number so:

Answer: There is no possible 6-number solution to this problem.

Mar 24, 2010 | Core Learning Calculation Skills: Volume 2...

2 Answers

Z740 camera repeatedly formating memory card


Hi there , after formate if you face the same problem then, its look like the memory card life is end. He complete his total image serial number. For example:
Life time card capacity is DSC 00000 to DSC49999.
If he reach on end then he does not have any serioul no for further photos. In that case you need to replace the card. Thanks.

Mar 20, 2010 | Kodak EasyShare Z740 Digital Camera

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...

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

How to format a sansa express mp3


I doubt this will still help you, but I had the same problem. I called the Sansa tech support number, and they ran me through a few things (none of which worked), and ended up mailing me a totally new one.

Jun 04, 2008 | SanDisk (SDCZ4-000-A15) MP3 Player

1 Answer

To turn hours and minutes into decimal


Let's say that the time is in cell C3.
Now in cell D3 type =C3*24
then format cell D3 as Number.

Hope this helps.

Apr 24, 2008 | Excel (SS8SATAS5128400R)

Not finding what you are looking for?

Open Questions:

0 Answers

TechUSA/CA&1.877.778.89.69&Avira Antivirus Support Phone Number? Call 1-877-778-89-69 is followed by great amount of people because this number is used for solving the issue of virus's problem . It works with the assistance of Avira Antivirus support phone number and therefore the number is 1-877-778-89-69.Our expert will give advice to you how can you protect better and faster your pc's or Laptop and other devices.Our Team is very experts and experienced. Avira antivirus offer technical support in a very price effective manner by means that of tollfree service at 1-877-778-89-69.Sometimes customer face the problem of pc or laptop hanging.you must tried to use that number to solve the problem of virus's or hanging problem.Our expert always available for solve the problem you just dial 1-877-778-89-69 and your problem will solved in sort time.So use that number for any Antivirus problem.It provide the facility of shorter wait time and faster help.If your computer is infected please call 1-877-778-89-69.USA TollFree No:-1-877-778-89-69.Our customer Centre is all Always Opened in24*7.We are Avira Antivirus Support USA. For Any Query Call US :-1-877-778-89-69 . Avira Antivirus Support Phone Number, Avira Antivirus Customer Service Phone Number, Avira Antivirus Tech Support Phone Number, Avira Antivirus support Helpline Number, Avira Customer support Telephone Number.Avira Helpdesk number,Avira Tech support Telephone number,Avira Security Tech Support Number,Free Avira Avtivirus Customer Support Number,Avira Customer Service Tollfree Number.

May 29, 2017 | Avira Computers & Internet

0 Answers

TechUSA/CA&1.877.778.89.69&AVGAntivirus Support Phone Number? Call 1-877-778-89-69 is followed by great amount of people because this number is used for solving the issue of virus's problem . It works with the assistance of AVG Antivirus support phone number and therefore the number is 1-877-778-89-69.Our expert will give advice to you how can you protect better and faster your pc's or Laptop and other devices.Our Team is very experts and experienced. AVG antivirus offer technical support in a very price effective manner by means that of tollfree service at 1-877-778-89-69.Sometimes customer face the problem of pc or laptop hanging.you must tried to use that number to solve the problem of virus's or hanging problem.Our expert always available for solve the problem you just dial 1-877-778-89-69 and your problem will solved in sort time.So use that number for any Antivirus problem.It provide the facility of shorter wait time and faster help.If your computer is infected please call 1-877-778-89-69.USA TollFree No:-1-877-778-89-69.Our customer Centre is all Always Opened in24*7.We are AVG Antivirus Support USA. For Any Query Call US :-1-877-778-89-69 . AVG Antivirus Support Phone Number, AVG Antivirus Customer Service Phone Number, AVG Antivirus Tech Support Phone Number, AVG Antivirus support Helpline Number, AVG Customer support Telephone Number.AVG Helpdesk number,AVG Tech support Telephone number,AVG Security Tech Support Number,Free AVG Avtivirus Customer Support Number,AVG Customer Service Tollfree Number.

May 29, 2017 | AVG Computers & Internet

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

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...