Question about Computers & Internet
I have numbers in this format 23.67- how do i total these numbers with - at the end of number.
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
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.
Posted on Jan 02, 2017
Tips for a great answer:
Jan 10, 2017 | Watches
Jan 19, 2016 | Computers & Internet
Sep 12, 2014 | HP 12c Calculator
Apr 11, 2012 | Texas Instruments Office Equipment &...
Mar 24, 2010 | Core Learning Calculation Skills: Volume 2...
Mar 20, 2010 | Kodak EasyShare Z740 Digital Camera
Aug 26, 2009 | Microsoft Office Professional 2007 Full...
May 29, 2017 | Avira Computers & Internet
May 29, 2017 | AVG Computers & Internet
46 people viewed this question
Usually answered in minutes!