Over 1 million tech questions and answers.

Adding numbers within a cell

Q: Adding numbers within a cell

Not as easy at it sounds!

I have a cell with the following:

C16W45Y108

I need excel to calculate the total of these figures e.g =
16
45
108

this should give me a total of 169.

These figures are random e.g.
Y189
F2C77W10Y177

in each of these i would like the totals to be show eg:
Y189 - is 189
F2C77W10Y177 - is 266

Im stuck....

Read other answers
RELEVANCY SCORE 200
Preferred Solution: Adding numbers within a cell

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

RELEVANCY SCORE 59.2

Bloombery reports its U. S. Treasury rates every 15 mintues by gining the bidding and the yield in the same cell (100-30/4.13). I only want to use the price number, which is 4.13. Is there a way I can just import the price?
 

A:Disregarding certain numbers in a single cell

Import using what?

Do you have to parse the cell before importing, or can you have the parsing done after import?

Is the format from Bloombery(g) in a uniform format that allows rules regarding character positions?

Again, impossible to comment unless we know what you are using to import (excel, access etc)
 

Read other 2 answers
RELEVANCY SCORE 58.4

I'm using a =IF formula to return a chosen text value based on the number of days away from a date (based on the current date).

EX: in cell E7 I have =IF((B2-E6)>34,"DUE CAL","FMC")

whereas: B2 is today's date and E6 is the last date of calibration for a piece of equipment

To this =IF formula I want to add another =IF formula that will return a different chosen text if a comment is placed in cell E6 instead of a date (indicating that there is something wrong with the equipment).

Since I can't know what text would be input into E6, how can I set up the =IF formula based only on the presence of text, rather than something specific?

See attached example...

Help!
 

Read other answers
RELEVANCY SCORE 58

I am trying to create a worksheet that will help with constructability issues for solar projects. I will explain briefly the physical problem that I am trying to solve ahead of time with excel.

I add flashings to certain rafters on the roof. These flashing then contain the stands that holds the rails to the roof. The rails come in 11 foot sections and I often have to splice rails together. The problem is that I cannot have a splice at the same distance as the flashing/rail stand. So....

I have created a row that with some data input calculates where all my flashings will go. I have also created a row that automatically shows me all the rail lengths I need. Below that I have created a row that reflects where the splices between the rails will go. What I would like to do is create a cell for each splice measurement that tells me if that splice measurement if within 6 inches of any of the flashings. I will call this the Conflict cell.

I have successfully created a way for the Conflict cell to alert me if the splice measurement is the same as any of the flashing measurements, but I can't figure out how to have it show if the splice measurement within 6, plus or minus, of the flashing measurements.
Here is an example of one of my conflict cells
=IF(O4=0,IF(C11=C16,1,IF(C11=D16,1,IF(C11=E16,1,IF(C11=F16,1,IF(C11=G16,1,IF(C11=G16,1)*0))))))
(This probably doesn't make sense without the rest of the table)

Any ideas?
 

A:Excel- Finding A Range of Numbers (Plus or Minus) from one cell

You can achieve what you want by using an array formula.
These have to be typed in and then entered with the key combo CTR+SHIFT+ENTER
See attached for "my formula" which looks like this:
{=COUNT(IF((C11:G11>=(C9-E9))*(C11:G11<=(C9+E9)),C11:G11,FALSE))}
 

Read other 1 answers
RELEVANCY SCORE 58

I need help on this.
I have a minimum of 50 numbers in one cell. What I want is split those numbers into 50 different cells.

Ex: A1 would be 21364790461234585960485938475811293849388223344123

I need to split the numbers into multiple cells; 1 number in 1 cell.
So in A2 it should be 2
In A3 it should be 1
In A4 it should be 3
In A5 it should be 6
In A6 it should be 4
And so on....
 

A:Split numbers in one cell into multiple cells in excel

you could use the mid function

so assuming in cell A1

A2 = Mid(A1,1,1)
A3=Mid(A1,2,1)
But you would need to type that in
a better way is to use the row number to get the start position and then you can copy
ROW(A2)-1 to get the start position - if in a2 will return row as 2 , -1 = 1
and can be copied down

A2 = Mid($A$1, ROW(A2)-1, 1)
and just copy to row 51

see attached
 

Read other 3 answers
RELEVANCY SCORE 57.2

Hi

I have a column of data which contains a reference followed by the customer name.

examples:-

Cell B1: 0111213729 rivett luke
Cell B2: 0122022157 fernandes de souza henrique
Cell B3: 0803141945 lopez fernandez eduardo

I am using excel 2007 and want to find the code to separate the number from B1 into cell C1 and the name in B1 into Cell D1.

I would be most grateful for any help with the appropriate formulas.

Many thanks
 

A:split numbers & text in a single cell into 2 cells, xl2007

are the numbers always 10 digits
and do the numbers always have a space between the number and the customer

couple of ways

you could use a
=MID(B1,1,11)
=MID(B1,12,50)

if the number is variable but always the first space is between the name
=MID(B1,1,FIND(" ",B1,1))
=MID(B1,FIND(" ",B1,1)+1,50)

Rather than 50 - if the customer name is possibly longer - you could use the len() of the cell
=MID(B1,FIND(" ",B1,1)+1,LEN(B1))
 

Read other 1 answers
RELEVANCY SCORE 56

I have a company that sends people out into the field, the job may take more than one day and they may sell the same and different items each day. I am looking for an easy way to total these things up. I know Excel pretty well, but I can't figure out macros. What I would like to do is;be able to input Item #'s, have it look up the Description (which I know how to do), then I enter amount used, then on the side somewhere have it "auto sort" and "auto total" in either format as shown in Option #1 or #2 (I would really like it to show Option #2 & 1) Then I can review it with each item listed in order and give it to my secretary to enter into my invoicing program.

Item # Description Amount used
101 Truck 1
102 Pencils 6
205 Paper 8
215 Eraser 4
318 Envelope 10
101 Truck 3
319 Paper Clip 2
102 Pencils 5
318 Envelope 8
101 Truck 5
217 Ink 2
319 Paper Clip 8
205 Paper 2
215 Eraser 4


Option #1
Item # Description Total Used
101 Truck 9
102 Pencils 11
205 Paper 10
215 Eraser 8
217 Ink 2
318 Envelope 18
319 Paper Clip 10
Option #2
Item # Description Total Used
101 Truck 1
101 Truck 3
101 Truck 5 9
102 Pencils 6
102 Pencils 5 11
205 Paper 8
205 Paper 2 10
215 Eraser 4
215 Eraser 4 8
217 Ink 2 2
318 Envelope 8
318 Envelope 10 18
319 Paper Clip 2
319 Paper Clip 8 10
 

A:Adding numbers from jobsheets

Read other 10 answers
RELEVANCY SCORE 56

Could somebody help me . I need to print a Word file, but every print has to be numbered. There surely must be some way of doing it automatically. HELP
 

A:Adding Numbers to a Printout

print out of what in what program
adding what type of numbers

assuming word
assuming page numbers
assuming XP

on the top menu
Insert
page numbers
 

Read other 3 answers
RELEVANCY SCORE 56

Please can you tell me how to add page numbers to documents in Libre Office Writer.

Thanks
 

Read other answers
RELEVANCY SCORE 56

I need an Excel formula that will add a column of numbers by the date in which they (each number) occurred. The dates and numbers in sequence (which helps). For example, to add all of the monthly payments (by month) that will occur between 10/1/04 and 10/1/05 (in this case one payment per month) what could I use as a formula?

Help would be appreciated as Hurricane Francis blows right over my head here in Orlando.
 

A:Adding numbers between know dates

Here ya go: http://www.dicks-blog.com/excel/2004/03/sumif_between_t.html
 

Read other 1 answers
RELEVANCY SCORE 55.2

Im using windows 10 totally updated version and the problem im facing is that windows keeps adding numbers after my WiFi name/SSID and the number keeps on increasing. It aint causing any trouble with network usage but I still wanna fix it and wanna know whats causing this. Ive attached a picture with this thread where u can see the wifi name states Redmi 7 but my network name is just Redmi. This 7 was 2,3,4... some days ago. Please help me asap with this issue ill be grateful.
 

A:Windows keeps adding numbers after my WiFi name

I don't understand why that is a "problem" or why you are bothered, but I don't need to understand. In Network Connections you can right click on the connection name and select Rename and call it whatever you wish (within reason). I should add that you could do this in previous versions of Windows but I'm only assuming the ability has not been removed in Windows 10.
 

Read other 1 answers
RELEVANCY SCORE 55.2

Hello,

I am having trouble with Excel 2003 automatically adding the last digit in a Postal Code. For example, when I type in "R3R 4K5" in A1 and then click the corner of it and drag it down a couple of cells it goes from "R3R 4K5" to "R3R 4K6" and "R3R 4K7" and so on.

Is there an option that you can disable to prevent this?

Thanks!
 

A:Solved: Excel adding numbers

Read other 10 answers
RELEVANCY SCORE 55.2

I have a new 11e laptop, 3rd Generation. Everything was working good. All of a sudden, the keyboard when typing only the middle row letters of "a,s,d,f, j, k, l, ;" a number will be added in front or to the back of the letter. All other keys are typing fine. I have checked for anything NumLock that could be related to causing this. Nothing in BIOS Set. Checked keyboard settings - the correct language is set. I tried to press FN+F11 and nothing. I turned on the online keyboard and clicked on NumLock there and turned it off, that did not fix it. I attached an external keyboard, that types fine. Turned on and off num lock, that did not fix it. I did a restore back to a date before it happened, that did not fix it. I just reimaged the laptop and that did not fix it. Any suggestions would be much appreciated!

Read other answers
RELEVANCY SCORE 55.2

Is there some way to make it so page numbers display on the printed pages of an Adobe .pdf file? I converted a Word document to .pdf, but the Word document did not have the numbered pages. I now want to add the numbers in Adobe Reader, but it looks like I'll have to go back to the original Word document, add headers which include the page number, and then re-convert it to .pdf. Is that correct? If I could do it within Adobe Reader, that would be preferable.
 

A:Adding Page Numbers to .PDF document

The file is a creation from an original Word file, the page numbers would need to exist in the Word file.

It would be a nightmare if in creating a PDF it was able to assign new printed page numbers as these would often not align with the original document and TOC's would be incorrect.
 

Read other 1 answers
RELEVANCY SCORE 55.2

Hi All,

Anyone know how to add and total up numbers in a table cell? Thanks.

npd
 

A:Adding and Total Up Numbers in a Table

Read other 6 answers
RELEVANCY SCORE 55.2

How can I add the same cell to itself?? and then have the value given in another cell??

EXAMPLE

A1 to be used over and over to create a running total.

so...A1=A1+A1 and for it to keep the value.
so, it would be like 20+20+20 = 60 and the value 60 stored in another cell
perhaps A2

I can write a program to do this, but it would be DOS based, and I don't have the time...so any help would be greatly appreciated.

I know I can creat continuous cells to do this, but I don't want to do that, because I would have a page full of enteris, when I believe it should be possible to creat a running total with just one cell.

Thank you for any help you can offer!
 

A:Adding same cell

Read other 7 answers
RELEVANCY SCORE 54.8

About a year ago, I created an input form that contains a subform in which are listed all the contributions of a member of the organization. Under the subform -- IN THE MAIN FORM, not within the subform -- I had placed a field that summed the contributions for that individual, and another field that displayed the domain sum (DSum) for all contributions. Both have worked perfectly every since.

The field that sums the contributions for the individual used the formula "=[Contributions subform].[Form]![ContribSum]". The field that does the domain sum is "=DSum("Contribution","Contributions")+IIf(DSum("MatchAmt","Contributions") Is Not Null,DSum("MatchAmt","Contributions"),0). I removed the field "MatchAmt" from the table, and changed the DSum statement to just "DSum ("Contribution","Contributions").

After doing that, both field yield only "#Error". Part of my puzzlement is the field "ContribSum". It is not a field in either table, and is nowhere in either form. I haven't the foggiest where it is or why the formula refers to it. I tried using just "=Sum([Contributions.subform].Form![Contribution]), but that for some reason reports only the first contribution; doesn't add all of them up.

So my question is, how does one sum number fields in a subform in a field OUTSIDE of the subform/in the host form?

Help!
 

A:Adding numbers in a subform (Access 2000)

Put the "=" back in front of DSum, so that it says this:

Code:
=DSum("Contribution","Contributions")
The "#Error" means that Access is trying to do some sort of operation that it can't pull off.

As for your sum question, it's cagey, unless you can program a little. The workaround is this:
In the subform, show the form footer. There should be a control there called ContribSub, I'm guessing, from your post. If not, make one.
Set its control source to

Code:
=Sum([Contribution])

Once you're sure the subform sum is working, you can set the Visible property of the form footer to false. That way you don't see your total down there.
Now you can build a control source on the master form whose control source is set to

Code:
=[Contributions subform].[Form]![ContribSum]

As for why your other attempt wasn't working (the one that goes like "=Sum([Contributions.subform].Form![Contribution])"), you must remember that Access maintains only one "active" record at a time, per form or subform. So your control wasn't lying; I'll bet changing records in the subform would prove that. But it's only adding the total of the active record--this is the big difference from a report, where there are no active records.

Hope this helps. Let us know.
 

Read other 2 answers
RELEVANCY SCORE 54.4

Help! I have spent hours trying different formulas and searching the web for help. I am hoping you can help me.
I have Excel version 2011. My operating system is Mac OS X Version 10.7.5. If you look at the file I have attached you will see columns highlighted in yellow. In each column there are 2-3 different scenarios. I can't seem to get it right!

What I am trying to do is determine the AVR (After Repair Value) of a property I purchased. I've put in the formulas for "totals," but can't figure out the formulas for the columns. If you could just help me with one column I'm sure I can figure out the others.
Thank you
Cindy
 

A:Adding three different functions in one cell

Read other 16 answers
RELEVANCY SCORE 54

Hey!

I don't know it it's appropriate subforum to ask it, but as i'm under Windows 7 i thought it might've been a right place to start with.

Technically what i mean is i've got a row of numbers in notepad, like:

555555
543434
645454
454545
etc

What i'd like to do is automatically put a syntax in front of these numbers, like:

thisdoesthat?id=555555
thisdoesthat?id=543434
thisdoesthat?id=645454
thisdoesthat?id=454545
etc

I've got tens of thousands of such numbers, thats why it has to be done automatically.

Can you do it somehow with CMD perhaps? Or do you need any external program. If so, which one?

Thanks!
 

A:Adding random syntax in front of numbers automatically?

Read other 11 answers
RELEVANCY SCORE 54

Hello All,

I am using batch manager in Omnipage Professional 17 to convert batch of PDF files to text files using Omnipage.

Now the problem is i want to add some indicator specifying page numbers to separate different pages of PDF files in my text file.

as an example suppose there is an PDF file with 5 pages getting converted to a single text file using Omnipage then i want to add page number in my text file to separate each page content available in PDF file pages.

I went through help docs of batch manager but do not find any configuration option to do this.

Please let me know if anyone have solution for this.

Thanks,
Piyush.
 

A:Omnipage + Adding Page Numbers to PDF File pages

Maybe this will help you http://www.a-pdf.com/number/ . It's a free utility to add page numbers to pdf files.
 

Read other 2 answers
RELEVANCY SCORE 54

Hello i'm new here and i'm wondering if anyone could help me figure this out.
what i have on my sheet now is two cells with two different formulas but i would like to have both in one cell will that be possible?

the formuals are : =IF(J15>0,J15*I15,K15*H15)
and the second one is :=IF(J15>0,P15*J15,O15*K15)

does posting the formulas help?
thanks for anyone that can help.
 

A:Excel2003: Adding two formulas in one cell

Read other 13 answers
RELEVANCY SCORE 54

Hello,
Is it possible in one cell to show the total of both the column and the row? The idea is that it would be a double check because they should add up to the same thing. I am working with Windows 2007.
Thanks.
 

A:Solved: adding row and column in same cell

Read other 9 answers
RELEVANCY SCORE 54

I am trying to figure out a formula for a specific cell that will:

Add all of the "1" values in a given range and multiply by 10
Add all of the "2" values in the same range and multiply by 9
... etc.... to add all the "10" values and multiply by 1 (or basically not multiply by anything)

Then add these new values together to come up with a final number.

Does anyone have some way to do this?

BTW, all of the "1", "2", etc... values are actually vlookup results. I don't know how that will mess up the formula.
 

A:Solved: Adding cell values

Read other 11 answers
RELEVANCY SCORE 53.6

Hello group,

I wasn't quite sure how to word the subject line. I would like to be able to add a number to column A everyday and have the cumulative sum of column A show in column B in the adjacent cell so I can chart it. So it would look something like this:

1 1
1 2
1 3
2 5
-1 4

I think it's something to do w/the SUM function but I can't quite figure it out. Any help much appreciated.

Harold
 

A:Solved: Excel: Adding Numbers in a Column on a Daily Basis?

Read other 7 answers
RELEVANCY SCORE 53.2

I am Excel for my monthly budget. I have a check box in each cell that I check when the payment has been subtracted from my account. I want to be able to add the values of the checkbox cells to determine how much of my monthly bills have been paid so I can determine how much I actually have in my account.

The checkboxs are from the forms tool bar. For example
A1 $100
A2 $30
A3 $50
The $100 and $50 dollar payments have been subtracted from my account and I have put a checkbox in those cells. What can I use to add the amounts together if the checkboxes are checked?

I hope this isn't to confusing. Thanks for any help.

Donie
 

A:Adding values of a cell if a check box is checked

Bump
 

Read other 1 answers
RELEVANCY SCORE 53.2

I am quickly, I think, starting to pick this VBA stuff up a little but I have run into a problem. I Have a series of checkboxes on a sheet. They are ActiveX boxes. Each one of these boxes is tied to a row of data, say 5 columns long. What I want is when I user checks the box on this sheet it takes those 5 rows of data and appends them to another sheet, in the same workbook. I want the user to be able to use these checkboxes to make a list on the other sheet. I have a few pieces of VBA together but I keep getting errors trying to tie them together. I thought, I should define the range I want the list to go into on the "target" sheet, then find the first row without value in that range and append there. It is giving me fits though. Any ideas or other postings I could look at would be great.
 

A:Solved: Checkbox adding value to another cell on different sheet

Read other 8 answers
RELEVANCY SCORE 53.2

Hi All,

I have tried to merge these two formulas in Google Sheet:

=DATE('Resource Matrix'!K1,'Resource Matrix'!F1,1) &" - "& OR(WEEKDAY($G2)=7,WEEKDAY($G2)=1)

but seems not working.

DATE('Resource Matrix'!K1,'Resource Matrix'!F1,1) is to identify how many days there is in a month

OR(WEEKDAY($G2)=7,WEEKDAY($G2)=1) is to highlight if the day is weekend.


 

Read other answers
RELEVANCY SCORE 52.8

Hi,

I want to add manually data\formulas to my excel sheet and I get a popup error message:

please see the attached file.

ps: I unprotected the sheet.

Where do I set the flag to allow to add data to my cell. It doesn't allow me to add in some cells. Why is that?.. Some work and some dont..

Thank you
 

A:Solved: error adding data to excel cell.

The cell is "protected" with Data Validation. Activate the cell and go to Data/Validation and either delete the Settings or click the Error Alert tab and set the Style to Warnng or Information.
 

Read other 2 answers
RELEVANCY SCORE 52

Hi, I am having a problem with an Excel sheet - when trying to add a comment to a cell, the view seems to shift upwards, so suddenly I am looking at a completely different set of cells, but still the comment box of the cell I was editing, and am them required to scroll back down to find that cell. There are 1012 rows of information in the sheet and probably several hundred comments.

Any help would be much appreciated
Thanks
 

A:Excel: adding comment to cell causes sheet to shift upwards

Check the comment's alignmnet? This is new to me.
Which version of excel are you using?
 

Read other 3 answers
RELEVANCY SCORE 50.8

In cell j, I have formula =IF(SUMPRODUCT(ISNUMBER(SEARCH("VLXP",K2:AB2))+0)>=1,"Yes","No") that returns yes or no if VLXP is contained in any cell K2 through AB2 and it works correctly. What I would really like to do is then put into cell j the entire matching cell content or if not found return n/a. Is there a way to accomplish this maybe with VBA?
 

A:Solved: Excel if cell contains vlxp then put matching cell data in current cell

Read other 6 answers
RELEVANCY SCORE 49.2

hi, i have 2-excel cells in the same sheet, both contain manually entered numbers; cell-2 changes frequently; if the existing entry in cell-1 is < than the new entry in cell-2, cell-1 should immediately reflect this new value. how do you create this formula?
 

A:Solved: excel-replace content of cell-1 if cell-2 is > cell-1

Read other 8 answers
RELEVANCY SCORE 48.4

I am using outlook contacts and would like to add phone fields to the phone numbers in the detailed address view e.g. another mobile , home 3 , business 3 , packet 8 etc...
I tried everything and consulted every book , but no way . The addition will show up if I switch to phone list , but not in the detailed view .
Any suggestions ???

Thanks ,

M.K.
 

Read other answers
RELEVANCY SCORE 45.2

Hey everybody.

I don't know if the title is a good one for this problem, but here goes.

I have a column that has numbers in this format: 54321-1234

Now, I want to take off the last 4 numbers, and the dash, from all the numbers in the column, using a formula. So that the output would be: 54321.

I want it so the first 5 numbers stay the same, but the dash and last 4 are gone. Is this possible?

Thanks.
 

A:Solved: Excel 2003: Replacing Large Numbers with Smaller Numbers

Read other 13 answers
RELEVANCY SCORE 44.8

This was asked before by KlausdB:

"I have 4 x HDDs on SATA AHCI (Intel Controller) in Native Mode and 1 x ESATA on Win 7 Pro X64.
I noted that looking in Admin. Tools\Computer Management\Storage (as an example) the 1st HDD (Port 0 in the AHCI BIOS) is showing as "Disk 2" instead of my expectation of


"Disk 1".
Selecting the Drive's Properties correctly shows the "Location 0 (Channel 0, Target 0, Lun 0)".
I also note that the Disk Number allocation in Windows will change randomly after some reboots/startups - going anywhere from "Disk 1" to "Disk 4".  I can force/replicate this


behaviour by removing the ESATA drive.
Is this expected behaviour?
It doesn't appear to create any operating issues at this stage, however, is there a way I can force the Drive to always map to (eg) Device 0 --> Disk 1, Device 1 --> Disk 2,


etc?
Thanks."


 This was answered by Nicholas Li:

"As far as I know, how the disk is plugged physically and the order it is displayed are not related. For a simple example, if a drive is plugged to SATA interface 4 and it is the only disk, it will be displayed as Disk 0. If there is no related issue about
the disk order, I think we can safely ignore this."


 Because the topic was closed I want to ask a new question here:
 What happens if one of the 4 HDD drives or 5 has an OS installed on it? I ask because windows always write some bo... Read more

Read other answers
RELEVANCY SCORE 44.4

I have three SATA hard drives :
Main system/boot drive , WD Caviar Black 1 TB, connected to the SATA 0 port
A backup drive, identical WD Caviar Black 1 TB, connected to the SATA 1 port
Another dirve, Hitachi 1 TB, connected to the SATA 2 port
When I installed Win 7, only the main drive was connected... and it remains the only drive with active/system/boot partitions.

QUESTION 1.
All three drives reporr correctly in the BIOS, and in the right order, but why is it that only one of the drive (the one on SATA port 1) has a "SATA:" prefix and the others have a "HDD:" prefix ?

QUESTION 2,
Why is it that the assignment of Disk #0, 1, 2 ( as seen in Disk Maanger or DiskPart) does not seem to have nay rhyme or reason?

I would have expected:

- the hardrive connected to SATA port O, to be assigned as Disk 0
- the hardrive connected to SATA port 1, to be assigned as Disk 1
- the hardrive connected to SATA port 2, to be assigned as Disk 2

but instead, I have:

- the hardrive connected to SATA port 2, is assigned as Disk 0
- the hardrive connected to SATA port 0, is assigned as Disk 1
- the hardrive connected to SATA port 1, is assigned as Disk 2

Just curious why that is.

I am assuming there is no way to chagne this. Its not something I would dream of reinstalling Windows 7 to correct ( even if it did correct it).

A:SATA port numbers vs assignemnt of Disk numbers/

Best advice, leave it alone. It may bother your (and others) sense of order but it won't affect how anything works, and no re-installing Windows won't change it.

Read other 9 answers
RELEVANCY SCORE 43.6

I have been given four transcripts of telephone calls recorded at a call centre. All at different times on the same day. Two have the same callID number. The sequence of the numbers attributed to each call are odd. The first call has a higher number than later calls and the last two are also out of order. I am not sure if this is the right forum but i am desperate for some help. The transcripts are VERY important and I cannot be sure that they are the real deal because of the callID numbers. Any suggestions? Thank you in advance.
 

Read other answers
RELEVANCY SCORE 43.6

I have Windows XP, with Wordpad v5.1 and Notepad v5.1 as well. In Notepad, if I toggle off Word Wrap, I can then toggle on the Status Bar, and it shows me the line and column number in the status bar. It does not look like Wordpad has the ability to show line and column numbers. Does anyone know if there is a way to show that in Wordpad? Thanks.

Read other answers
RELEVANCY SCORE 43.6

I was checking my program and software list and at the top of the list I noticed two (2) sets of numbers that I have never seen before. I checked the internet to see if I could find out what they were. It kept taking me to sites for spyware, adware,etc. I could not find out what they were or why they are on my system. I do not want to remove them until I know what they are. I have not noticed any problems with my system, but I do not know what might be going on behind the sceen. The numbers are listed as follows:
{684CB795-C157-4E15-93D4-E26015FEF1EA}

{F850707C-B6A0-4B56-8709-F89CF8F9AC6D}

ANY HELP?

A:Found Numbers Unknown Numbers In System

The first one > http://www.acresso.com/products/is/i...d-overview.htm

The second one > http://eraser.heidi.ie/

Both are legit and not malware.

Read other 1 answers
RELEVANCY SCORE 43.2

I have a sheet with 2 simple columns: Date and Price. I have imported the dates (##/##/####) and the prices ($###,###) by copy/pasting from the search results given to me by a niche database program I use. When the cells paste in, they all have the format "General".

When I try to format the "date" column into dates, it _does_ change the format as far as the cell is concerned, but the content of the cell doesn't adapt to the new format. For example, I have the date as 3/05/2001 and when I change it to a date format of MMM D, YYYY the content should change to March 5, 2001 but it doesn't. It is as if all the cells are forced to stay as text regardless of what the formatting is that I'm applying.

Same problem with the price column: if I change the format to include 2 decimal points, that format does apply to the cells, but the content of each cell remains without a decimal or anything following, as if the content is just text.

I have like 1000 rows in each column, and plan to do this analysis of the database's results frequently, so I'm hoping the answer isn't just to retype the data. There's got to be a way to copy/paste or export or something. Maybe I could copy/paste into notepad first to scrub out any formatting or locking from the niche database program?
 

A:Excel 2007 Cell Values Won't Take On Characteristics of Newly Applied Cell Format

Good news: Made some progress. In thinking that maybe each value had the textual single-quote forcing it to act like text, or maybe if I find/repaced all the dollar signs and commas that had been imported, I accidentally discovered that each and every value in my imported columns has a following space!

Bad news: Seems like Excel has a bug that thinks that if I say "Find=[singleSpace]" "Replace=[null]", then I should be given an error saying "Excel cannot find any data to replace". I think I'm doing the find/replace correctly because it worked on the dollar signs and commas.

Anybody know a workaround for the bug?
 

Read other 1 answers
RELEVANCY SCORE 42.8

Hi Tech teams, I went to the lenovo site to customize a T440S Thinkpad and got stuck at the REAR BATTERY selection. I have searched in google and the site and could not see the picture difference's between 6 Cell Li-Ion Cyl HC Rear (72Wh) and 6 Cell Li-ion (47Whr) Cylindrical. I know those will be large and will bulge out of the laptop. But I would like to understand in which way and want to see the pictures of the laptop fitted with these 2, so that I can proceed with my order. Will it come out like a cylindrical bulge at the back of the laptop or at the bottom it will have an extra step like thing. Why dint the lenovo put 3 different pictures showing the laptop with these batteries in the "help me decide" option while customizing the laptop. That would have been very nice to the customers. I have wasted 2 hours to compose this and search everywhere, without any resolution. I found a similar thread in some forum, asking for the pictures, and no one replied him as well. Please see the below screenshot.  ThanksManu

A:Difference between 6 Cell Li-iion Cyl HC Rear (72Wh) and 6 Cell Li-ion (47Whr) Cylindrical

Hi,
 
look at Notebookcheck review

Read other 6 answers
RELEVANCY SCORE 42.8

I'm attempting to write my first macro for an Excel 2003 workbook. I'm not completely code illiterate (I've got moderate skills with AutoLISP), but I'm new to VBA and am not yet an Excel power user, so please be gentle.

The macro I want to write will:
check that the selected cell's content is underlined before proceeding
copy the content of the currently selected cell into an external plain text .log file
.log file lines should be: year/month/day - time - username - cell contents
.log file names will probably need to be generated
clear the cell's content and formatting (particularly underline and text/background color)
Here's what I have so far:
Code:
Sub Unpost()
If Selection.Font.Underline = True
Then Selection.ClearFormats And Selection.Clearcontents
Else
If MsgBox("The selected cell is not underlined...are you sure?", vbOkCancel) = vbOk
Then Selection.ClearFormats And Selection.Clearcontents
Else Exit Sub
End If
End If
End Sub
If I've written it correctly, it should currently do everything except log the cell contents. This, from what I've seen, is going to be the trickier part. I intend to use this macro 50+ times per weekday, so at some point the .log files will get too long to be useful, so I assume it will need to automatically create new logs (perhaps "year-month.log"). I've seen some useful info about appending to an external log here and here, ... Read more

A:Excel 2003 macro: log contents of selected cell, clear cell

You need to use the "File Scripting Object" to create and/or append text to a file. I've included a link below to get you started. If you are unable to figure it out on your own let me know and I'll write the code for you.

http://www.virtualsplat.com/tips/visual-basic-fso.asp

Rollin
 

Read other 1 answers
RELEVANCY SCORE 42.8

I'm working on a spreadsheet at the moment which displays a range of cells all containing values referenced from another spreadsheet (within the same workbook). This system works fine.

Every day, the original worksheet is updated. So, it has fields already arranged up until the end of the year. A row for every date. Now, needless to say, rows for dates in the future contain no values, and so when the spreadsheet I am working on now references those cells, it displays "$0.00" (which is correct, given I am dealing with financial figures).

Now, all of that works as expected, however, on the spreadsheet I am working on, all of those figures are displayed in a line graph. This line graph, at todays date, shows an enormous drop given that the fields for the rest of the year all show a zero balance.

What I need to do, is to get the remainder of those fields (every field that says "$0.00") to not display anything at all. So, if the value is $0.00, it would not display a value at all, and therefore not show anything on the graph.

Can someone tell me how I can achieve this? I'm sure it can be done with an "if" statement, but I'm not sure how to structure it.

Any help would be greatly appreciated.
 

A:Solved: Remove Cell Value If Cell Value Is Zero (Microsoft Office Excel 2007)

=If(a1="","",Sheet1!a1) and drag it down.

Where a1 is the first cell in spreadsheet you are working on, and sheet1!a1 is the sheet within workbook containing figure.

Not sure if the graph will recognize the "blank' cell as blank or "0"
You could try that

Pedro
 

Read other 3 answers
RELEVANCY SCORE 42.8

Hello Everyone! :-) This is my first time posting at this forum.  I have a Lenovo T520 laptop that is experiencing intermittent problem shutting down when I am trying out brand new 9-cell and 6-cell batteries that are fully charged.  Based on the seller instruction; they said to go into the bios to see if there is a battery resync option and/or charge the battery with the laptop powered off for a minimum of 10hrs before using the new battery.  I followed their instructions but the laptop continued to suddenly powered off while I am using it with a fully charged battery.   Has anyone experiences similar issues and know of any troubleshooting method or fixes?  Of course I first naturally expects the battery to be bad, but I bought 2x 9-cell batteries, the seller then send me an additional 2 x 6-cell batteries because I am having problems with the 9-cell.  The 6-cell also resulted with the same symptom so I find it hard to believe that all 4 batteries are bad.   Here is the info on the batteries I purchased:  https://www.ebay.com/itm/9Cell-Battery-for-Lenovo-ThinkPad-T410-T420-T510-T520-SL410-SL510-E420-E425... Thank you in advance for anyone that can help me to resolve this problem. Best,Vinh Le

A:New OEM 9-cell & 6-cell batteries causes laptop to suddenly shutdown with full charge

Hello and welcome,
 
I can't say with certainty what is going on - but those aren't OEM (Lenovo) batteries.  They are unbranded generics from who-knows-where.
 
I'm always suspicious of non-OEM batteries and their internal control electronics.
 
Z.

Read other 2 answers
RELEVANCY SCORE 42.8

I copied a cell from sheet 4 and pasted a link in the target cell (on sheet 1) and the number that was perfectly shown in the source cell was shown twice in the same target cell on sheet 1 of the same Excel 2016 spreadsheet. I have included a partial screen shot of sheet 1 to show the actual image of the double number.

Bottom right cell is a link to the other worksheet (sheet 4) in the same Excel file and in that source cell the number is 12542.09?. For some weird reason, it is showing up here twice in the same cell. This is the second time in the past few days this has happened but the first time I was able to DELETE or CLEAR CONTENTS and it stopped doing that. But not this time.



I am running Excel 2016 on a PC with an Intel Quad processor under Windows 10 Home.
Any thoughts?
 

Read other answers
RELEVANCY SCORE 42.8

I have a sheet set up with the list with the description (text) in column B, and summary scores (numerical, percentage) in column D. I want to do a summary row at the top of the sheet that pulls the data from the B cells, based on the lowest 3 values in column D.
 
I plan on using the formula =SMALL(D7:D32,1) (with d7:d32 being the list of percentages), to figure out the lowest 3 values. But the formula just pulls the summary score, not the description. I want to pull the description into but I am at a loss.
 
I am using excel 2013 on windows 10. Any help would be appreciated.

Read other answers
RELEVANCY SCORE 42.8

I have a sheet set up with the list with the description (text) in column B, and summary scores (numerical, percentage) in column D. I want to do a summary row at the top of the sheet that pulls the data from the B cells, based on the lowest 3 values in column D.
 
I plan on using the formula =SMALL(D7:D32,1) (with d7:d32 being the list of percentages), to figure out the lowest 3 values. But the formula just pulls the summary score, not the description. I want to pull the description into but I am at a loss.
 
I am using excel 2013 on windows 10. Any help would be appreciated.

Read other answers