Over 1 million tech questions and answers.

Adding numbers between know dates

Q: Adding numbers between know dates

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.

RELEVANCY SCORE 200
Preferred Solution: Adding numbers between know dates

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

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 63.2

Hi,
I have disabled every auto-correct and auto-format option I can find, but Excel still won't stop changing my numbers to dates. If I type 1-2, it automatically changes it to 2-Jan, and so on. I'd really appreciate any suggestions you can offer me. My bio grade appreciates it, too. Thanks.
 

A:Excel Keeps Changing Numbers to Dates

Have you tried formatting the field(s) to text?
 

Read other 2 answers
RELEVANCY SCORE 62.4

Good afternoon!

Hope someone here can help!

I produce a report in excel that has rolling information spanning back over a year and for some reason, between my saving the file with this months data and my boss opening it a day later, all cells containing numbers using general format have been changed to 00:00:00.
Cells that had already been set to a date format were not changed and the data is still available somewhere in the cell as all my graphs are still showing the correct info. Even all numbers on my Y axis are 00:00:00!!!

I have subsequently established today that my colleague is experiencing a similar issue, whereby all data in her reports is being changed to a date format of "dd mmm 1900" whenever it is saved.

In both instances, we have reformatted all cells back to general or number (whichever is suitable) and saved the file, only for it to revert back when we re-open.

I have attached an example which shows just one tab from each of the reports to show an example of what is happening - you will notice that any formulas and graphs are still calculating correctly, it is purely the view that keeps going wrong!!

Any help anyone can offer will be gratefully received.

Thanks and regards,

Chalkie247
 

A:Excel re-formatting numbers to dates or times

you are getting the data from an external source - has this source changed its format at all
what is the source

do you update the data from external source each time you open the spreadsheet

who owns the external data /database you are using
 

Read other 3 answers
RELEVANCY SCORE 62.4

When I enter a number like 2-2 it shows up as 2 Feb. What do I need to do to enter the numbers?

Thanks-
 

A:Excel-I enter numbers and they change to dates

Read other 9 answers
RELEVANCY SCORE 61.6

In Windows XP, WordPerfect 10 tables, suddenly all the dates in the dates column change to numbers. Is this a virus? Or can I do somthing to get my dates back? I deleted the column from the table and then added a new dates column and put back all the dates, and that was fine for two days, and then while adding data to the table, the dates suddenly changed to numbers again. PLEASE HELP!
DilbertO
 

Read other answers
RELEVANCY SCORE 61.6

I would appreciate help with an excel formula. I am not a techie so I would appreciate if responses are as transparent as possible. Column J lists participant start dates and Column K lists participant end dates. There are a myriad of start and end dates and many participants so the sort function does not suffice. I am hoping that it is possible to write a formula in which I can check total participants onsite on any given Monday (or week) of the year. Any help would be great. Thanks very much.
 

A:excel: participant numbers based on start and end dates

Read other 6 answers
RELEVANCY SCORE 61.6

I have a table in which the first column is numbers. Sometimes there is a range eg 3-4 in which Calc auto changes it to a date eg 3-4 becomes 03/04/08

I've tried rummaging through its menus but can't find the solution. Changing the date format for a particular cell makes that cell look ok, but I'd have to do that for individual cells becuase copying it to the whole column spoils those cells which contain a single digit, not a range.

I'm sure there's an obvious solution, but right now I can't find it. Any help will be much appreciated!

Edited to add:

Changing the cell format to text, or All, to avoid it being read as a number, does somethign even stranger, eg 4-5 is changed to 39572
 

A:OpenOffice Calc - how to stop it changing numbers to dates?

Read other 7 answers
RELEVANCY SCORE 61.6

I am having issues with my thunderbolt connecting to an external monitor box (Plugable USB-C) among others and in making sure I have all of the latest drivers I went and installed the latest thunderbolt drivers. The Lenovo link for the Thunderbolt 3 driver for your system - https://pcsupport.lenovo.com/us/en/products/laptops-and-netbooks/yoga-series/yoga-920-13ikb/80y7/dow... But when I installed it they said the "new" driver did not install even after I installed it while it was connected and disconnected. I tried about 6 variations of power off/power on/... So I dug in farther. When the drivers installed I looked at the driver version that is printed out on the screen and it shows that it's different than whats on the package. The attached picture shows the driver that it installed is 17.1.64.2 and the dates are May and June of last year. But the install page says it should should be 17.1.64.250 and the dates should be Jan 2018 or maybe Dec. Could this driver install package be messed up? It would explain why I the new drivers are not being installed.  Anyone have any ideas?Ken

Read other answers
RELEVANCY SCORE 61.2

I am exporting report data from an accounting program into Excel 2003, then having to change some of the worksheet data into to a specific format (some columns show dates, phone numbers, etc - which need to be converted to text - translation:HEADACHE) and then saving file as ".csv" to submit reports online to another agency. I am pulling my hair out here because it keeps changing to funky formats in the .csv sheet and I find myself back at square one. I am required to do this on a monthly basis, and will soon be submitting a similar file to a different agency, so I will double my headache if I can't get my head wrappred around this.

Any help would be great!!!

Thanks.

I'm running XP Pro sp3, Office 2003
 

Read other answers
RELEVANCY SCORE 60.4

Dates are automatically converted to numbers (only in one file). As you can see in the screenshot below, the dates are automatically converted into numbers so somewhere in the document a settings must have changed.
Before I format the cells:
After formatting (this should be the default setting)

Is it also possible to change a default setting in a pivot table?

I'd like to change the default setting "Count" to something else.

Thanks for your support

Vince
 

A:Dates are automatically converted to numbers + Change pivot default setting

You have to format that field to as a date value too, it's numeric now
 

Read other 1 answers
RELEVANCY SCORE 58.4

Cell A1 is formatted "mmm./dd/yyyy" (Apr./27/2010)
In cell B1 if I put in formula "=A1+1" I get the "dd" added by one. (Apr./28/2010)
How would I formulate cell B1 to be "A1+1=next month? next year? (May./27/2010) or (Apr./27/2011)?

In short, how do I formula cell B1 to be A1 + month or day or year?
Thank you for your help.
 

A:Solved: Adding Dates

Use the DATE() function which has arguments of year, month, day in that order.

For date + 1 month use:
Code:
=date(year(a1),month(a1)+1, day(a1))
For date + 1 year use:
Code:
=date(year(a1)+1,month(a1),day(a1))
HTH
 

Read other 2 answers
RELEVANCY SCORE 58.4

Excel 2007
Is there a formula to create a calendar of 1st Sundays of each month?
eg: For Year 2012;....1/1/2012.....2/5/2012........3/4/2012.....etc.
If I use the "edate" formula, it only adds a month to the previous month. Not what I need.
Thank you for your help.
 

A:Solved: Adding Dates

Read other 7 answers
RELEVANCY SCORE 58.4

Hi,

I have list of receipts, with the date in column A, and receipt amount in column F. There are several receipts on any given day. What I'm trying to do is work out the sum of receipts up to yesterday, to give me a balance carried forward to which I can add today's takings, giving total receipts for the month.

The way I've tried doing this is as follows:

=SUMIF('[Receipts - February.xlsx]Daily Receipts'!$A$6:$A$399,"<A4",'[Receipts - February.xlsx]Daily Receipts'!$F$6:$F$399)

Where A4 is todays date. It's giving me nil value, which I can clearly see is wrong. How do I work out the total receipts before a given date?

Thanks for any help.
 

A:Solved: Adding using dates

Read other 8 answers
RELEVANCY SCORE 58

As you can see in my attachment, I am trying to get the following result but the formula isn't working & I get a #value error:

If H9 = "A", then add 1 day to the date in I9
- or-
"B", then add 14 days to the date in I9
- or-
"C", then add 90 days to the date in I9

Thanks!
 

A:Solved: Adding Dates in an IF formula

Read other 12 answers
RELEVANCY SCORE 57.2

HI all, I am new to this sit and I am looking for some help. I am looking for a way to add a PDF calendar to outlook and have the dates in the PDF link to the calendar in outlook. I am not sure how or if this is possible, If it isn't possible is there a way to add excel or word docs with dates and be able to send them so add attachments that can link to the recipients outlook calendar.
I hope I explained this well enough. I appreciate any feedback thank you.
 

Read other answers
RELEVANCY SCORE 56.8

Hi,

I am trying to create a Command_click macro that collects the input info for sickness / holiday / appointments in the excel cells then...
Grabs the info from the cells
Checks outlook if the entry already exists
If it doesnt add the entry
EXAMPLE of excel data

dateto | datefrom | starttime | endtime | description | location
25/01/2011 | 26/01/2011 | 08:00 | 15:30 | Dave Smith | holiday
26/01/2011 | 27/01/2011 | 08:00 | 15:30 | Dave Smith | holiday
29/01/2011 | 30/01/2011 | 08:00 | 15:30 | John Smith | holiday
EXAMPLE of macro in excel
Code:

Sub CommandButton2_Click()

Dim olApp As Outlook.Application
Dim olApt As AppointmentItem
Dim blnCreated As Boolean

'Read the table with appointments:
Dim arrAppt() As Variant, i As Long
arrAppt = Range("A2", Cells(Rows.Count, "F").End(xlUp)).Value
On Error Resume Next
Set olApp = GetObject(, "Outlook.Application")
If olApp Is Nothing Then
Set olApp = CreateObject("Outlook.Application")
blnCreated = True
Err.Clear
Else
blnCreated = False
End If
On Error GoTo 0

'Create the outlook item for the table entries:
'Rows:
' Row 1 = date
' Row 2 = starttime
' Row 3 = endtime
' Row 4 = Description
' Row 5 = Location

For i = LBound(arrAppt) To UBound(arrAppt)
Set olApt = olApp.CreateItem(olAppointmentItem)

With olApt
.Start = arrAppt(i, 1) + arrAppt(i, 3)
.End = arrAppt(i, ... Read more

A:Adding dates from Excel to Outlook and checking there are no duplicates

Read other 6 answers
RELEVANCY SCORE 56

I'm working on a filter to show which Drawing Changes are overdue by selecting check boxes that have certain overdue periods. (e.g. 1-14 days past due, 15-30 day past due, 31-60 days, etc.) I'm not very good at VBA but I'm using some code I have from a search form I used a while ago that has a date filter. I'm confident I can figure out the code for the filter, but I'm not sure how to say what I want to happen in VBA code. What I want the filter to read is this:

If 1-14 days is checked, include entries that (Due Date + 14days) >= Today's date
If 15-30 days is checked, include (Due Date + 30days) >= Today's date AND (Due date +14days) < Today's date
and so on.

I'm using Access 2010 on Windows XP

Thanks for any help!

Dobber9
 

A:Solved: Creating a Filter and Adding dates in VBA Access 2010

Read other 8 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

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

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

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

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

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

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

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

Hi – I need some help.

I have a log that lists the start date and end date of my fleet of cars. I want to be able to tell how many cars we had in our fleet on any day (and then be able to average out the number of vehicles in a month)

What I have is two columns with the first containing the start date of the car and the second containing the termination date of the car.

Example

Code:

21/04/2006 20/04/2010
21/04/2006 20/04/2010
27/04/2006 26/04/2010
28/04/2006 27/04/2010
1/05/2006 28/04/2010
3/05/2006 29/04/2010
3/05/2006 30/04/2010
12/05/2006 11/05/2010
17/05/2006 1/05/2010

On another sheet I have dates starting 1/1/2003 incrementing by a day up to 2013. What I am looking for is a way to count how many times each of the dates falls between (or on) the date in each of the ranges.
EG in the example data above 5/5/2006 = 7, 6/5/2006 = 7, ..., 12/5/2006 = 8. (I hope! )

Note - I am using dates in the format DD/MM/YYYY

Hope you can help!
 

A:Solved: Counting number of times dates occure between range of dates

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 48.4

Once again I'm reaching out to the TSG forums for help. I have a column (bid request date) and another column (bid approved date). In my pivot table I have a count of these by my team members. # of Bids Submitted and # of Bids Approved and I want to add another column into the pivot table, "Approval rate" which divides the # of Approved by # of submitted. Is there an easy way to do this in a pivot table?
 

Read other answers
RELEVANCY SCORE 47.2

Hi there I tried linking my serial number and product number of my laptops  with my hp passport, but that does not seem to to work. The warranty checker start date november 2014 but we bought them in october 2015, so we are a year out. How do I update these, and am I able to link them to this hp passport account. Thanks for your time. All the best Matt

A:Warranty dates do not tally with my purchase dates

Hi melton , In this to get you warranty to be update please do contact the HP support line of your country with the Proof of purchase with the serial number on it . So that they would work on it and get it updated . HP Worldwide Telephone Numbers  http://h10032.www1.hp.com/ctg/Manual/c00047049.pdf Also as you have the the passport account  you can raise a request throught the support case management . r-K //Click on Kudos and Accept as Solution if my reply was helpful and answered your question// I am an HP employee!!

Read other 1 answers
RELEVANCY SCORE 45.6

Hi there,

I have a whole column of dates in this format in my table: 20080602

I want my macro to change the format of the dates from this 8-digit number string, into a date format that Excel can recognize (6/02/2008). Once the dates are re-formatted, I then want to have the macro select rows with dates that are up to four days of age only for the new report.

Here is what I've got to format the dates. When I run it, the macro stops at this point and tells me to debug, telling me I have a 'syntax error'. A what?

Columns("A:A").Select
Selection.Format = Date(left(a1,4), mid(a1,3,2), right((a1,2))
Once I do get the dates right, how would I get it to select dates that are up to four business days in age only? This is what I thought I should use, but it doesn't work:

Range("A1").Select
Selection.Format >=today()-4

Thanks!
 

A:formatting dates and selecting dates by age in vba?

I don't think that you can do what you want using the Format function as you have tried to do it. You are on the right lines with the Left, Mid and Right though.
in another column put this in a Cell on the same row as A1
=mid(a1,5,2) & "/" & right(a1, 2) & "/" & left(a1,4)
If that gives you the correct "look" then Drag that formula down the rest of the rows with Dates in. Then copy the whole Range of new look dates and Paste Special>Values over the first cell in that Range or in a new column and you should now have your Dates.
In the next column type in the first cell
= if(today() - Celladdress <= 4, "Yes", "")
Where celladdress is the cell with you first "Proper" Date.
This will place a "yes" in the column wherever the date is within 4 Days.
If this is not satisfacory and you really need to have a Macro to do this you can use the same "Formatting" in the Macro, but you will require a "For/Next or For/Each loop" to do it.
 

Read other 2 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 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.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 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 39.6

Hi,
I have some reference books I use and in all of them I have this problem:

The number written on the document pages doesn't match the number my pdf reader says, and for every document it has a different offset. That is, for example when I go to page 16, then on the page itself it's written that it's page 5 and not 16.

It's an annoying problem.
Is there any way to fix this by changing the pdf numbering or is there any workaround?

Thanks
 

A:pdf page numbers donÂ’t match document page numbers

Read other 16 answers
RELEVANCY SCORE 38.8

Hi, so far i have managed to make my program so that it prints out the odd numbers between two inputted numbers but i need it to print the sum of them?
This is what i have:

public static void main(String[] args) {
int int1, int2, sum = 0;
Scanner scan = new Scanner(System.in);
System.out.println("Please enter two integers: " );
int1 = scan.nextInt();
int2 = scan.nextInt();
for (sum = int1; sum <= int2; sum++){
if ( sum %2 != 0 ){
System.out.println("" + sum);
}
}
}
}
 

A:Java: Sum of all odd numbers between two numbers?

Read other 9 answers
RELEVANCY SCORE 34.8

There are several issues that came up when I upgraded to Windows 10. While it is a celebrated and supposedly eye pleasing application, it seems that they have chosen to disregard users and deleted certain preferences from a user's browser.  This makes
it practically impossible for the user to log into several accounts, since every single site requires different types of passwords, and in order for a person to be able to log on to the several accounts, a person would have to carry around a folder with about
100 different account names, user names, passwords, answers to who, what, or where, phone #s & other pertinent information to be able to log onto or recover a lost or forgotten password.I really do not like what Microsoft has done with the new browser.
It looks chick, but to me it's unworkable and a nuisance to use.  If the Cadillac is not broken, why fix it?

Read other answers
RELEVANCY SCORE 34

I'm new to SQL.
I'd like to run a program in SQL once a week. I only want records updated since the last run. There is a field called processdate. I only want where processdate> today-7. How do I code that in SQL
 

A:SQL dates

Read other 6 answers
RELEVANCY SCORE 34

Can any one tell me why my notebook updates every time I shut down.
When I check resent updates It doesn't show any resent updates.
Claire

Read other answers