Tech Problem Aggregator

# Counting the Spans of Zeros between non-zero values

Q: Counting the Spans of Zeros between non-zero values

I have data of the monthly total of purchases by each customer. It looks something like this: 0,0,0,100,200,0,0,300,0,0,0,20,0,250,0,0. All in separate cells in a row. I want to be able to return the values of 2,3,1. I need to find a way to count the amount of zero values between the non zero values. With or without the amount of zeros following the last nonzero number is a little less important. For reference I have a formula to count to the amount of months since the first purchase and also the amount of months since the last purchase. They are the following: =COUNT(DD2:INDEX(A2:DD2,MATCH("",T(1/A2:DD2),0))) and =ROWS(A2:DD2)-MATCH(2,1/(A2:DD2>0))+108. Any Help would be greatly appreciated. Thanks PS using Excel 2010 I believe

A: Counting the Spans of Zeros between non-zero values

Try the array formula below in DL2. Confirm it with Ctrl + Shift + Enter instead of the regular Enter. Fill down through all of your rows, then fill right as far as you need to. In each column it should list the size of the gap between non-zero entries. See attached for (hopefully) more clarity: =IFERROR(SMALL(IF(\$G2:\$DJ2>0,COLUMN(\$G2:\$DJ2)),COLUMN(A:A)+1)-SMALL(IF(\$G2:\$DJ2>0,COLUMN(\$G2:\$DJ2)),COLUMN(A:A))-1,"") The results I've checked appear to hold up?

4 more replies

Hi all,

I have an excel sheet with numbers of different users, numbers of different municipalities and in each record a code for a status:A-B-C-D-E-H and X.
I would need to calculate for each user the total of occurrences of the different statuses, as well as the overall total of all his records. For instance user nr 100 has 45 records, with 20 A statuses, 15 B statuses, 10 C statuses, etc...
Thanks in advance for any help.

Eddy

A:Counting the occurence of certain values for several users

9 more replies

While opening some games , the display seems to sweep away from monitor like it tends to display as if on a TV rather than n monitor and therefore only partial of image/desktop screen is visible. I tried a lot to change the properties of nvidia control panel.. Can someone help me out with this..
I have attached a screen shot.. please check it

While not on games its fine..
im using 1280 * 1024
Geforce FX5500 256 mb

6 more replies

My span is currently two 2TB and one 1TB disks. So I have a "virtual" 5TB hard drive. If I purchase a 4TB drive will Windows be able to add that to the span? I have a feeling since the 4TB drive needs to be partitioned as GPT (and the others don't) it might not work. Spans also require the disks to be converted to dynamic drives and I'm not sure if this has any effect on the 4TB drive.
Thanks a bunch.

A:Can Win7 Create spans with 4TB & 2TB drives

anyone? bump

1 more replies

Hello Everyone,
(This is kind of long but I didn't know how else to explain everything)

There are two parts to my question below.

I have a spreadsheet with roughly 40 columns

An Example of some of the columns would be:

Code:

B1 = Client Name E1 = Travel F1 = Backup G1 = PC Install H1 = Data Recovery | X1 = Total | AE1 = Summary
B2 = Tony Smith E2 = \$70.00 F2 = \$0.00 G2 = \$95.00 H2 = \$0.00 | X2 = \$165.00 | AE2 = (See Below)
B3 = Tom Daniel E3 = \$70.00 F3 = \$0.00 G3 = \$0.00 H3 = \$725.00 | X3 = \$795.00 | AE3 = (See Below)
B4 = Rene Little E4 = \$70.00 F4 = \$125.00 G4 = \$95.00 H4 = \$995.00 | X4 = \$1285.00 | AE4 = (See Below)

Currently this spreadsheet is being analyzed to be used to track field technician jobs and figure everything out for accounting.

I have been asked to please make a cell with a list of the information above so that accounting can just copy and paste from that cell into quickbooks in order to send these people out a receipt instead of having to retype everything into quickbooks. This list has to be based upon whether or not there is a value greater than 0 within that cell then it will grab both the heading cell in the first row and the value of that cell it was checking and place it as a line item in another cell.

I know how to do half of what they are asking and if I was dealing with 1 column I can do the other half.

I know how to list items in 1 cell using the c... Read more

A:Excel: Checking values on multiple cells and transferring values to 1 cell

16 more replies

This is the code i got so far it will go though and pick the users that have the appropriate status "A" and paid "No". I need it to then copy those users that are appropriate to the Mail Extract sheet. I think i am ment to have a Dim or something in there arn't I. The macro is under the Modual 1 Thingy... If you can help me please do so PLEASE. The data to be copyed is on the Band Members sheet.

=======================================================
Sub MailExtract01()

!!! I know i need some DIM stuff here too!!!

'If filtering
Sheets("Band Members").Select
Range("A3").Select
ActiveCell.Offset(0, 5).Range("A1").Select
For Each Cell In Range("Status")
If ActiveCell.Text = "A" And Selection.Offset(0, 2).Text = "No" Then

!!! This is where i need the copy code to go, I think !!!

End If
Next Cell
Sheets("Mail Extract").Select
Range("A1").Select
End Sub
=======================================================

I need the code to filter though every person and check if the status is “A” and the Paid is “No”. After the filtering I need every person with an “A” under Status and “No” under Paid to be copied to the “Mail Extract” worksheet. I have got all the code to filter though the cells but how do i get this to then copy the appropriate members to the "Mail Extract sheet. There is a code of the file i am working on attached to this post.

Any help will be ... Read more

More replies

This is the code i got so far it will go though and pick the users that have the appropriate status "A" and paid "No". I need it to then copy those users that are appropriate to the Mail Extract sheet. I think i am ment to have a Dim or something in there arn't I. The macro is under the Modual 1 Thingy... If you can help me please do so PLEASE. The data to be copyed is on the Band Members sheet.

=======================================================
Sub MailExtract01()

!!! I know i need some DIM stuff here too!!!

'If filtering
Sheets("Band Members").Select
Range("A3").Select
ActiveCell.Offset(0, 5).Range("A1").Select
For Each Cell In Range("Status")
If ActiveCell.Text = "A" And Selection.Offset(0, 2).Text = "No" Then

!!! This is where i need the copy code to go, I think !!!

End If
Next Cell
Sheets("Mail Extract").Select
Range("A1").Select
End Sub
=======================================================

I need the code to filter though every person and check if the status is “A” and the Paid is “No”. After the filtering I need every person with an “A” under Status and “No” under Paid to be copied to the “Mail Extract” worksheet. I have got all the code to filter though the cells but how do i get this to then copy the appropriate members to the "Mail Extract sheet. There is a code of the file i am working on attached to this post.

Any help will b... Read more

A:Excel: Checking values in multiple cells and transferring values to another worksheet

16 more replies

In sheet 1 Column A has current values, Column B has the new value for each entry.

Column A Column B
Old value New Value

Document 1 SOP-001
Document 2 SOP-002
Document 3 SOP-003

In sheet 3 has a list of entries
Column A

Document 1
Document 3
Document 3
Document 2
Document 1

What formula can I use to automatically replace the value SHEET3:ColumnA with the appropriate value from SHEET1:column B? The lists are quite long. Resulting in a list on sheet 3 that looks like this:
SOP-001
SOP-003
SOP-003
SOP-002
SOP-001

A:Solved: Excel-Substitute values from a list of new values

Hi bongiojf, welcome to TSG.

You can do this with a vlookup formula, assuming that the old values are in the leftmost column and that they are sorted alphabetically.

On sheet 3, in column B (or any blank column) use this formula for the first cell and then copy it down the rest of the column:

=VLOOKUP(A1,Sheet1!\$A\$1:\$B\$3,2)

Change the range \$A\$1:\$B\$3 to be the range of data you have on Sheet 1. The number 2 at the end of the formula indicates that the new values are in the second column from the left. If they are not, change the number accordingly. For example, if they are in column D, the value would be 4.

Once you have the new data in your blank column, you can copy the column and paste special/values over the existing data on sheet 3.

Hope that helps.

1 more replies

I want to insert into my database; 1 of the fields is a 'created' field. eg if its August then is I need to create a variable in vb with August in it. ANd Date onComm is Today's date (now).But the rest of the fields are from an linked xcel spread sheet. How do I code this? At present I have in SQL
INSERT INTO CommCustomer ( Accno, Contractno, DateonComm, Amount, CommDate )
SELECT [ Acc] AS Accno, Milcar.[Contract No ] AS Contractno, Now() AS DATEonComm, [ Rec] AS Amount, MonthName([DateonComm],True) AS CommDate
FROM Milcar
WHERE ((([ Rec])<>0));

But I get invalid procdure call; I actually want it in VB.

sql = "Insert INTO CommCustomer (Accno,CommMonth,Contractno,DateonComm,Amount)" & _
"SELECT "[ Acc], [Contract No ], [ Rec], " & _
" FROM Milcar " & _
" WHERE Rec <> 0 ;"

So my question is how do I insert 2 fields that are not from the select clause - I actually need to use values from them?

A:Insert with Values and values from a Select clause

6 more replies

Good morning,

I will try to explain this best to my knowledge. I have a worksheet that will work as a report. This report will be based on Contracts. In one file (Physical) I can have multiple contracts. All linked to the same file number.

Example if file number 1234-45678 as 2 contracts then my code will automatically add the information required, adding 2 contracts for file number 1234-45678.
Therefore my initial row 5 (Example only) will add a new row underneath and will add the following information:

A5: 1234-45678 B5: 002 C5: 1234-45678/001/HS
A6: 1234-45678 B6: 002 C6: 1234-45678/002/HS

So my column A will always be the same linking the 2 contracts. 1234-45678/001/HS and 1234-45678/002/HS belong to file number 1234-45678.

If I need to make an amendment, in house an amendment is to make modification to a contract. In my column B I will always have the amount of contracts. In the example above the amount for Contracts is 002.

If I make an amendment and the reason of the amendment is a Termination, therefore cancelling one contract to create another one, I need to be able to change all information in my Column B vs All information from Column A. So for Example:

If
A5: 1234-45678 B5: 002 C5: 1234-45678/001/HS
A6: 1234-45678 B6: 002 C6: 1234-45678/002/HS
And I need to make the above modification then I need to add another Contract but change all information from my Column B (Made in a userform, already establish). So the above example will become:

A:Add Values in column And change Values in another column vs .find match function

The code for Sheet5 ("Report") is the following:
Code:

Private Sub Worksheet_Change(ByVal Target As Range)
Application.ScreenUpdating = False
Application.EnableEvents = False
On Error Resume Next

'This function will add a new row if the number is higher than 002
If Not Intersect(Target, Range("M5:M1000")) Is Nothing Then
NumRows = Target.Value - 1
For R = 1 To NumRows
Target.Offset(1, 0).EntireRow.Insert
Next R
End If

'This function will copy the information onto the next rows adding a /??? and /HS
'This will depend on the number that the user has inserted in "Contracts" in Column B
If Not Intersect(Target, Range("M5:M10000")) Is Nothing Then
On Error Resume Next
For i = 1 To Target ' stops the code looping
tmpArr = tmpArr & "," & i
Next i
With Target

With .Offset(, 1).Resize(.Value)
.NumberFormat = "000"
.Value = Application.Transpose(Split(Mid(tmpArr, 2), ","))
.Formula = "=A\$" & .Row & "&""/""&TEXT(ROW()-" & .Row - 1 & ",""000""""/HS"""""")"
.Value = .Value
End With

.Offset(0, -12).Copy .Offset(0, -12).Resize(.Value)

3 more replies

Ok..get ready for this one. I was having a virus issue on my comp..maybe i still am. I used superantispyware and after all said and done, i couldnt connect to internet. I did the ipconfig release, and it said it already has been released. Then i did the ipconfig/renew.. it said: an error occured removing area local interface connection. The rpc server is unavailable. I know the address shows all zeros. I know its the computer cause i have 3 other comps and they all work fine. Please keep responses laymen terms. Im not a computer guy here..but kinda know my way around one.

6 more replies

Hi everyone! I'm new here and this is my 1st post ever.

I'm an XP user and I need help regarding my NIC, when I check for the mac in ipconfig it's all zeros. I've tried disabling media sensing and it's no use as well (it's not working prior to that as well) . I've tried reinstalling, no luck. The led is normal too.

The main concern is routing is intermittent, it's like a disco light, no route, route, no route, route, it's so frustrating! My connection is via wireless (motorola antenna directed to station), there are no obstructions as well regarding line of sight.
I suspect my NIC's broken but I have to confirm this before I call in any technician.

I'll appreciate any help and thanks in advance!

14 more replies

Hi everyone,

I need to enter serial numbers into an Excel document. Many of them begin with multiple zeros, which Excel drops automatically. I need them to show, and the only way I've been able to keep them is by adding the prefix "#," but I really don't want this.

Any help is greatly appriciated,

Dave

A:Zeros in Excel...

If you change the number format of the cells to Text, it will keep the 0's.

3 more replies

I am trying to create a database in Microsoft Access to catalog all of the books in my possesion. I have set the ISNB Number field as the Primary Key for the database but when entering a number that begins with a zero the program removes the zero once I move on. Is there a way to make it leave the number alone after I enter it. The zero does have meaning when looking for a copy of the same book and it is essential that it be included.

Thanks in advance for all your help. Any and all feedback is welcome.

A:Removing Zeros

11 more replies

I had an unusual happening on my PC. First noticed some instability while trying to open a file from Explorer, could not scroll down to file and it was jittery. Then, every time I tried to enter on an input line, an endless string of zeros were input and I could not overide or erase. Even on Email addressees. I tried a reboot and the zeros appeared on the start up password line and I could not logon. Same thing after complete power cycle. I suspected a stuck key on the keyboard and tried a different keyboard but no help. So I tried a complete restore. At first, it seemed to have the same problem, but somehow, eventually, I got logged on and now everything seems OK. But I don't really know what caused this and fear it could happen again. Virus?? or something. I have Norton.

A:Zeros Input

2 more replies

Is there a simple VBA code I can use to search a single row and clear the contents of all cells with a value of zero? Thanks.

A:Clearing Zeros

Just select the entire row or a range of cells and run the following macro.
Code:

Public Sub ReplaceZero()

For Each vCell In Selection.Cells
If vCell.Value = 0 Then
vCell.Value = ""
End If
Next

End Sub

Rollin

1 more replies

Anybody know the best method for clearing a hard drive before getting rid of it? I have a hard drive that needs to be replaced and is under warranty. It is an OEM, so there is no software from the manufacture to write zeros or anything. I plan on first doing an FDISK and then using a program to write zeros or patterns or whatever. First....does anybody have a suggestion as to a better method to go about this.....and second.....does anybody have suggestions as to good programs to write zeros over teh drive?

A:writing zeros

6 more replies

OK here is my situation. My operation system is Windows 2000. I have an ASUS A7N8X-X motherboard.

My problem started when I got the SurfSideKick 3 Virus on my home PC. Long story short, I ended up reloading my operating system onto my second harddrive to get rid of it. I got online to download the drivers for my motherboard (which includes my network card) from nvidia.com and loaded them on my home computer.

My problem comes from the fact that I still can't connect to the internet with my cable modem. Windows says that my network card is operating properly, and that my drivers are adequate.

When I pull up a prompt and ipconfig /all my IP address shows up properly (169.xx.xx.x), but my physical address shows up as all zeros. I borrowed another network card from a friend, same problem.

When I check the status of the LAN connection, it says that is sending data but not receiving. I called my ISP (Knology) to have them ping the modem and they said that it is working properly.

I have tried reinstalling the drivers a couple of times, but no luck.

Also, No Firewall, No Router.

Any help would be greatly appreciated.

More replies

so ive doing a spreadsheets and I have some restrictions, Ill use a example

~~B ~~C~~D~~E~~F
4~10~~10~~-~10
so basically I want the average of row 4 cells B-E, under cell F, so in cell F i type in =average(B4, C4, D4, E4)

my problem is, im not suppose to put a zero under D4 but im suppose to treat it as a zero, how can i do that in the formula?

A:treating spaces as zeros

7 more replies

Trying to upgrade XP to 7- issues along the way, but now boots under WIN7, have applied several rounds of updates, including SP1. Have some updates that won't apply, getting BSODs and lock ups. Have run SCF, no issues; Have run diskchk, no issues; Have run memtest, no issues; Have run CheckSUR - there's 16 manifests all zeros (listed below); Have looked on WIN7 upgrade DVD, the WINDOWS dir, and another system (but its a 64bit OS..) and can't find these manifests.

Any ideas ?

Code:

Binary Version 6.1.7601.21645
Package Version 15.0
2012-09-16 23:52

Checking Windows Servicing Packages

Checking Package Manifests and Catalogs

Checking Package Watchlist

Checking Component Watchlist

Checking Packages

Checking Component Store
(f) CSI Manifest All Ze... Read more

A:CSI Manifest All Zeros - where to find them?

Hi,

In order to completely troubleshoot Windows validation & activation issues, please perform the following:

2. Run the tool, and then click 'Copy' - ignore any errors if they appear

3. Use CTRL+V to paste the unedited results of the validation tool here in your next reply

Regards,
Golden

9 more replies

Is it possible to show leading zeros in an autonumber? In other words, we always want the number to be four characters (#1 would look like 0001). Also, how would I show leading zeros in another number that's not an autonumber?

Thanks for any help!

In design view of the table, click on the autonumber field. At the bottom, in the FORMAT box, type:

0000

2 more replies

I'm only a little bit computer literate. I've never really put forth any time to studying these things. I pretty much learn by troubleshooting problems as they appear. Anyway...

I was having computer issues, ran a hdd diagnostic, reallocated sector count below theshold. From what I gather that means the hdd is pretty much done for. No biggie, I'll get a new HDD. But before I pack the old one into a box, I want to write zeros through the drive. I've got everything off it I need and don't want to risk somebody else getting something off it I don't want them having.

I'm using WD's diagnostic tool and it's estimating that it will take 43 hours to do a full erase. I did a quick erase and it took less than 10 minutes. Is that normal?

A:Should it take 2 days to write zeros to HDD?

Take the HDD apart, that's always fun to do. When your done messing with take a hammer to the platter

6 more replies

Hi I am having trouble figuring out how to add zeros into the middle of a PHP alphanumeric input field. We are developing a php site that would allow us to search by a part number.

The problem is that in our database, the part numbers are formatted as such:
065V0012 or 075H0678 or 085M2345
Which are all formatted as (3 numbers, a letter, and then 4 more numbers).

But we publish our part numbers as a compressed version:
65V12 or 75H678 or 85M2345 respectively.

My question is how would we have the ability to type in a search box the compressed version 65V12, and get a database match to the fully formatted part number?

I would be enormously grateful if someone could help me on this one.

A:Add zeros in middle of PHP alphanumeric

It took quite a while to think a way to do this, it's quite a tricky thing to get the head round. I came up with this:
PHP:

\$prodID "65V12";

\$parts preg_split('/[a-zA-Z]/'\$prodID); //split the product id into the first number, and the second number(after the letter)

\$letter explode(\$parts[0], \$prodID); //split up the id using the first number, to leave the letter ... Read more

2 more replies

Hi I'm trying to solve a problem for my dad's machine. Since yesterday (out of the blue) often when he holds down any of the character keys (backspace, del, F, G, 5 ....absolutely anything) on the keyboard zeros will appear. Press once - fine, hold down - "0000000...". However sometimes it's fine and nothing happens. There seems to be no pattern.

I've run 3 separate scans (AVG, TDSS Killer, MalwareBytes) and found nothing so I don't think it could be anything to do with that. I can't seem to find any solution.

The Pc runs:
Windows XP Professional,
AMD Athlon XP 200+
NVIDIA GeForce FX 5200
1GB RAM
Maxtor 40GB HDD

Any help would be appreciated. Thanks.

A:Zeros appear instead of correct character

See if plugging in another keyboard solves the problem.

1 more replies

Hi. I'm working off of an Asus Eee PC with Windows XP. Recently, (even though I DO have a connection with a cable) my internet isn't working. I suspect it has something to do with the fact that my physical address is 00-00-00-00 etc. (all zeros), however, I DO have a physical address for my wireless connection (which still works fine). Help?

Thanks!

6 more replies

Two things:
First, what is the best freeware program out there for writing zeros to a drive in DOS? I want a program that I can just boot to the floppy and run it off of disk and easily write zeros over the drive. WD has this included in their utilities, but this is an OEM drive. I had this one program that was pretty good for this, but it only ran in Windows.
Second, any body have any tricks for recovering data on a failed drive? I have this WD drive that failed last August or September. (WD won't send drives to P.O Boxes, so I had to wait until I came home from school) When it was failing, I starting saving files by copying from this drive to another in windows, but it didn't work too well. After some time it would say the drive was disconnected and I would have to restart. At first it was after a few 100 MB and very soon it wouldn't really let me get into it so I quit. This was mid Sept and I haven't done anything since then. It has just sat disconnected in an empty HDD slot. There is about 50 GB on it and if possible I would like to just image it onto another HD. I don't think I'd get enough run time out of it to get into it and save all I want. If I can get it to run for a good 4 hours I should be able to just let it sit there and do the work.

I would like to hear anything and everything. The best method, specific processes.............whatever. Such as put the good drive on primary master and failed drive on secondary slave or what not... Read more

A:recovering data and writing zeros

16 more replies

Hey all! I have a huge problem with my computer, and now while posting these on the forums I'm using another computer, as well, the keyboard seems to have a problem with me.

Recently, my sister noted that while typing, zeros would appear. For example, while typing 'computer', it would appear as com0pute0r, or co0mp0ute0r. As the days passed the problem gets more and more irritating. It's as if someone is pressing the zero while typing. It is so disturbing, in fact, it does not only occur while typing, when the computer is idle, a warning sound will play repeatedly. (the sound when you press a keyboard button on the desktop, the 'Teng!' sound) It can't be stopped and I can't type anything since it keeps owning me with the zeros.Please highlight anything you don't understand as I'm trying my best to explain this problem, it is so complicated. I dare not do anything, nor am I using the affected netbook as I don't want any more problems to crop up. Please help.

A:Solved: Computer keeps displaying zeros! HELP!

6 more replies

Greetings!
I'm trying to save a CSV file with leading zeros. I've tried all of the excel tricks. (Here are a couple: use an apostrophe before the zeros, format as text. I've tried '0 and concatenate, using a long string of zeros and using the right() function [must have 5 digits].)

When I save the file (as a csv) and reopen, all the leading zeros are gone. The reason I need the format like this is because it must be imported into another application as comma delimited. Thank you for any suggestions.

A:Saving leading zeros in CSV format

I have just formatted cells as text, began the string with a comma, and then entered it all, saved as csv, closed and reopened, and the formatting was preserved.

You said you tried it with an apostrophe, but did you use a comma?

BTW, formatting as text will only show the 0's in Excel, as csv does not recognise the text format. In other words, you don't need it.

3 more replies

I can't remember. When booting from the disc and get the DOS prompt what do I type in. I just can't remember and it really bothering me. I sure I'll remember but I need to know now so I can have inner peace

A:I'm Getting old! What do I type in to get the software to write to zeros

7 more replies

on many pages that i surf to and even on allot of the software i try to run(the interfaces) i'm seeing lines of 'zeros' as opposed to the correct letters and,or numbers,etc..... this has never happened until recently. i recently bought some new software but can't run it because of this problem..is this a binary error?? i'm stumped and this is really inconveniencing and really aggrivating.please save me

A:Solved: zeros instead of intended characters

Run windows update and install the language packs.

1 more replies

Every time I start my computer I get a black screen with lots of zeros and if i start it normally i get a blue screen saying something about the driver. I'm going to attach two pictures of what it does. I've tried cleaning all the dust out of the fans, my drivers are up to date. I don't know what it is. any help would be awesome

I can't give specs of my computer other than i have a Nvidia 7500 v. card running on vista home, 2g ram, 32bit

A:Black screen with lots of Zeros

Suggest you:
(a) check Device Manager for any devices with a yellow tag.

4 more replies

I am trying to import delimited data into excel, and a large part of it is a number of columns of five number strings, some of which have leading zeros. Well, when I import them, Excel gets rid of the leading zeros. This complicates the end goal, which is importing from Excel into a proprietary app that filters for certain criteria, since this app only recognizes five-digit numbers and will boot the rest.

So my question is, can Excel's default to get rid of leading zeros be turned off? Or, obviously, is there another way I'm just not considering?

Thanks in advance for any help.

16 more replies

Microsoft Windows [Version 6.1.7601]
C:\Users\Kathy>ipconfig/all
Windows IP Configuration
Host Name . . . . . . . . . . . . : Kathy-PC
Primary Dns Suffix . . . . . . . :
Node Type . . . . . . . . . . . . : Broadcast
IP Routing Enabled. . . . . . . . : No
WINS Proxy Enabled. . . . . . . . : No
DNS Suffix Search List. . . . . . : gateway.2wire.net
Connection-specific DNS Suffix . : gateway.2wire.net
Description . . . . . . . . . . . : Realtek PCIe GBE Family Controller
Physical Address. . . . . . . . . : F8-0F-41-3E-4F-9C
DHCP Enabled. . . . . . . . . . . : Yes
Autoconfiguration Enabled . . . . : Yes
IPv4 Address. . . . . . . . . . . : 192.168.1.72(Preferred)
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Lease Obtained. . . . . . . . . . : Tuesday, September 25, 2012 2:52:58 PM
Lease Expires . . . . . . . . . . : Wednesday, September 26, 2012 3:13:01 PM
Default Gateway . . . . . . . . . : 192.168.1.254
DHCP Server . . . . . . . . . . . : 192.168.1.254
DNS Servers . . . . . . . . . . . : 192.168.1.254
NetBIOS over Tcpip. . . . . . . . : Enabled
Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . : gateway.2wire.net
Description . . . . . . . . . . . : Microsoft ISATAP Adapter
Physical Address. . . . . . . . . : 00-00-00-00-00-00-00-E0
DHCP Enabled. . . . . . . . . . . : No

A:all zeros in physical address in the cdm prompt

my ipv6 no network access what do i do anything?

2 more replies

How do I import a CSV file into excel keeping the leading zeros? Excel automatically drops the leading zeros when imported. I do not want to change the column format in the import wizard because I don't know which columns have leading zeros. Has someone figured out a way to import a file into Excel without dropping the leading zeros?

Welcome to TSG jeanniepie,
You have a dilemma. You don't want to configure the column format to text for the offending data. Without intervention Excel will determine that a group of numeric characters in a field is a ....Number. If you want it to be text you have to overide the logic and import as text.

This discussion at social microsoft describes many ways of doing what you want...most require you to know your data. --Depending on the data you may be able to import it all as text?

2 more replies

Im using a killdisk to remove all the junk on my computer and start over with a new OS.... would a "One Pass Zeros" erase method be sufficient to do this?

A:"one Pass Zeros" Wipe Of Harddrive

That should be fine. You do a the multiple passes when you sell a machine and you're paranoid that someone will hack into it and retrieve information.
Mark

3 more replies

During the course of this thread Recover data from a diskpart > clean command it became evident that the first NTFS (also known as Partition Boot Record / Volume Boot Record) in a HDD can be at LBA 63 (Absolute Sector 63) or LBA 2048 (Absolute Sector 2048) depending upon the partitioning utility used. This is actually the starting sector of the first partition.

Partition Wizard run from a bootable pendrive formatted a 750GB Seagate GoFlex external HDD with the first NTFS at LBA 63.

Windows Disk Management formatted the same drive with the first NTFS at LBA 2048.

In both cases it was found that the diskpart clean command zeroed LBA 0 to LBA 2047.

This should remove the common misconception that the diskpart clean zeros only the MBR at LBA 0.

Even I believed it to be so thus far till a debate/discussion between me and Anshad Edavana in that thread brought this revelation.

A:diskpart clean zeros LBA 0 to LBA 2047

I did one more DISKPART experiment with a XP partitioned disk ( partition start at LBA 63 ). Regardless of the starting position of first partition at LBA 63, DISKPART zeroed the first 1 MB and last 1 MB. It looks like this behavior is hard coded in "Windows 7" version of DISKPART ( Probably in 8 too ). It make sense because DISKPART doesn't have to bother about whether the disk is partitioned in MBR or GPT scheme by wiping out first and last one MB.

Official Microsoft documentation ( DiskPart Command-Line Options ) start by these words:

Quote:
DiskPart is a text-mode command interpreter in Windows Vista, Windows? XP, and the Windows Server 2003? family

It means the documentation was probably updated lastly on 2006. Even at the time of Vista, GPT was not popular and large capacity drives are very rare. Anyway since both Vista and XP are obsolete, there won't be any practical benefit in examining how legacy version of DISKPART works.

9 more replies

Hi. Using excel 2000 under Win-XP. While using my own VBA program to calculate a few simple figures and display them in a cell, I have noticed that the ROUND(x,n) function is returning 8.5 instead of 8.50, even though all appropriate fields are DIM'd as Currency.

Everything else works fine. Unfortunately, this means that I have to live with displays like this:
\$45.89, \$56.8,\$43.09 etc. I place all the figures in the same cell, so excel puts them there as a string, which is fine. Whilst using the VB editor, I can see that it is the ROUND function (or maybe excel itself) which is truncating the trailing zero.

Other than writing a special routine to add a trailing zero, is there something else I can do?
(I am leery of using a global STYLE setting because of potential complications).

Perhaps someone knows of a better ROUND function or Sub?
I assume that this is a bug in Excel, since I can't imagine why anyone would want to show an amount with only one decimal place where a zero is involved.

PS: I realize that I could give each amount its own cell and use a format to fix it that way, but I prefer to have a series of amounts separated by commas in one cell, in this case.

Thanks.

Feel free to email me directly.

A:Excel 2k missing zeros after dec point

"Other than writing a special routine to add a trailing zero, is there something else I can do?"

Not sure what lengths you don't want to go to. Have you tried (e.g.):

x = Format(Round(x, n), "\$0.00") & ", "

etc?

2 more replies

During the night my computer tried to restart and failed. A blue screen with zeros and vertical lines came ur and the computer could not start. Tried to do a system restore & then a system recovery with no luck. Would not nopen the recovery disc or the restore window. Just shut down and tries to start with no success. Any help?

More replies

A friend has run a test on his hard drive (10 GB) which has written all ZEROs. I have never heard of this test. Now he is unable to fdisk or format the disk. FDISK result in the statement there is no space for a partition. Format results in a full disk response. Oddly enough, the computer’s first error is that there is no drive 0. It is a Compaq Presario. Is there a way we can repartition and format this disk?
Thanks.

A:[SOLVED] ZEROs on hard drive

16 more replies

I'm using the Database program in Microsoft Works Vers. 6.0, and most of the numbers require a trailing zero, but I can't get it to do so.

I want to add something like, 460.050, and the program just gives me 460.05. The default setting for Decimal places is set at 7 (default, I think), so I should be able to get 460.050, or 854.0570 with no problem, but....

How do I get it to allow an extra zero, or zero's? Any help much appreciated, first time I've used program.

More replies

I have been having a probem in the past few weeks with text in various programs showing up on the screen as all binary zeros. It has been doing it on the buttons in Windows Media Player, and also in chat rooms. (It really makes it hard to chat when all you see are binary zeros.)

Im running Windows ME. I can take a screen shot if you need to see what Im talking about.

Thank You,
Jonathan Grubbs, NetPublicist
http://www.netpublicist.com/

A:Text Appearing as Binary Zeros

10 more replies

I have a field that contains values like 000003300000000000. I need just the four bold characters tokept and the leading and ending zeros to be removed. I have tried changing it to a number field but this won't work! Any ideas?

A:Access 2000 - Removing leading zeros

The answer indeed involved converting the string to a number. And it involves a funciton that is available for use in queries but only shows up in the help for VIsual Basic (not in the expression builder)

1) convert the string to number than back to text. this removes the leadin zeros:

for example if [Field1] = "000345000"

then
str(val([Field1])) = " 345000"

Note that the evaluation leaves a leading blank and didn't do anything about the trailing zeros.

We're going to end up using the VAL function again and it'll ignore the leading blank
so we needn't bother with it just yet. The big problem is to get rid of the trailing zeros. You can't do this simply but you could if the order of the characters was reversed.

Let me introduce the StrReverse function. Not shown in the expression builder list or Access expression help, it is explained in visual basic help. We'll reverese the expression and the trailing zeros will become leading zeros and we'll use Str and Val again to get rid of them to get just the non-zero portion of the string:

Field 1 = 0012345000
Str(Val(StrReverse(Str(Val([Field1]))))) = " 54321

BUT THEN, the string ends up backwards... THe best way tocare of that is simply to reverse tjhe string before everything else. Then, remember to trim the leading blank (using LTrim) that the STR function will leave when everything else ot done.

Thus

Field1 = 0009912800

3 more replies

Hi There

I'm struggling with a very simple macro.

Here is what I want the macro to do.

I have zeros in Column A. The zeros go from A1 to A11. I want the macro to do the following. If range("A1:A11") are all zeros then hide column A.

Thanks

Mario

A:Solved: Macro to hide column with zeros

7 more replies

I am attempting to report on a query with a linked proprietary database (I can't change data structure). In a client code field (variable length text, 12 characters) I only need 4 digits. What I get is 8 leading zeros and 4 (needed) characters. How do I remove the leading zeros?? I know very little about access (I am like a kid looking over a cliff with this linked db) and am not familiar with building expressions or functions. Please keep this in mind in your response. I learn fast, but will take everything you say literally! (If steps are involved, please don't assume I know them)

A:Removing leading zeros in numeric field

16 more replies

so im trying to format my 4 drives 2 1TB and 2 750's cuase im setting up a new home network and i want the drives to be super clean so i dont have any problems, im using seatools but im not sure if i should use write zeros or full erase whats teh difference in both and is there one thats faster than the other?

A:Write Zeros or Full Erase With Seatools?

7 more replies

Looking for assistance again! Thought I would put together a small script to let me allocate random names to files and at the same time add a Prefix or a Suffix as required. However, the problem I ran into was when I wanted the suffix to include leading zeros namely, if the file name was to end ..... 1.txt I wanted to have .....0001.txt. Providing 0001 in the suffix data input box did not work despite showing as .....0001.txt on screen. The resultant file came out as 1.txt. Using a function seemed to work on a single file until I remembered that a function doesn't work in a loop. Can any of you guys out there assist and point me in the right direction?

I've added my script below. It does what I want apart from adding the leading zeros but it's a bit rickety. The files I was testing it on are named:

Library_123.txt, Library_456.txt, Library_789.txt

Thank you

Code:

Option Explicit

'Define vars
Dim fso, f, intMax, iLoop, k, intValue, strChar, strName, intNum
Dim File, strPrefix, strSuffix, Tally, x, Pad, n

Set fso=CreateObject("Scripting.FileSystemObject")

' Characters available for random choice
Const Chars = "abcdefghijklmnopqrstuvwxyz123456789"

' Specify length of names.
intMax = 40

'Input File Prefix
strPrefix = InputBox(chr(13) & chr(10) & chr(13) & chr(10) & " Enter Prefix", "Data Input")

'Check point
wscript.echo " Prefix Entered Is: " & strPrefix

'Input File Suffix

More replies

I'm building 20 line graphs in 20 different tabs and I have a lot of zeros toward the end of my graph that I don't want to so as 0 in the line chart. Is there a way to have these listed as blanks?

See attached example

I've tried the "if(c29=0,"",c29)" but that still doesn't work.

More replies

Hi, I have been trying to remove zeros from a timesheet I have compiled in excel 2010 without using the predefined option to do this under Options. I therefore want to use a formula to do this which for one or two for the columns in the SS I have been successful. However, for the remaining columns I get the response "too many arguments".I have configured the SS to show regular hours or less and then any OT worked in a separate column, but I still get the zeros problem for any preceding empty values. Here is an example of the function I have tried to use where \$I\$8 is for a cell showing 8 hrs only, d10-c10 is for 17.00-08.00 for example and f10 is the result (I hoped). This works for a numerical value but also returns zeros in the empty cells of the F column.Any help with this formula would be much appreciated.Thanks=IF(\$E10>\$I\$8,\$I\$8,IF(\$D10-\$C10<8,\$D10-\$C10,IF(\$F10<1,"")))message edited by batar

A:How do I return zeros using nested IF functions in Excel

Something like this might work:=IF(\$E10<\$I\$8,"",IF(\$E10>\$I\$8,\$I\$8,IF(\$D10-\$C10<8,\$D10-\$C10,IF(F10<1,""))))It appears to be the I8 cell that is returning the zero, but without seeing what your sheets looks like, it is difficult.If you could post a small sample of how your sheet lookslike this:
C D E F G I
7)
8) ??
9)
10) ?? ?? ??
So we get a better understanding of what your doing, itwould help.Read this HOW-TO which explains the use of the < PRE > tagsto align your data like the above.http://www.computing.net/howtos/sho...MIKEhttp://www.skeptic.com/

11 more replies

I have a formula that uses the ROUND Function. When a number is displayed in a cell like 0.1, it does not display the trailing zero.

What is the best way to get the trailing zero to display. The format of the cell is general. I fo not want to change that to anumber because I would like the formula to handle the decimal places.

A:Solved: Excel Number -> Trailing Zeros

Well you will have to allow the format.
Could it be that the variable you defined is set to integer?
Try setting it to long.

Or else use (vba code) range(XX2).value = format(variable,"0.00")

2 more replies

Am trying to CF a range where condition I want is "If cell is greater than 1", so that if empty no conditional formatting.

Have ascertained by using ISBLANK that the value in cells is "0".

Edit / Replace cannot locate any "0's" nor can it find a "\$" I used to see is the replace function was working.

When I highlight the range and CF as "If cell is greater than 1" all cells in range respond where I only want the one with a real value in it.

Suggestions welcome.

Pedro

A:Solved: Conditional formatting hidden zeros

cells greater than 1
will not show up for 0 and 1

2 more replies

Hi. I'm getting errors when trying to do a Windows update to service pack 1 (Windows 7).

I've run CheckSUR, and it seems to be complaining about:

I've attached a zip file with both the checksur.log and the cbs.log.

I've tried looking in my Windows7 DVD for the file (ie. viewing the "D:\sources\install.wim\2\Windows\winsxs\" archive using 7zip). But that file doesn't exist there.

I'm out of ideas what to try next.

Thank you for any help with this,
Dan

A:Win7 update errors (CSI Manifest All Zeros)

Give this a quick shot.
SFC /SCANNOW Command - System File Checker

4 more replies

Hi All

Someone has asked me the following question and I can't find a way of doing it. She is printing - via mail merge - some raffle tickets, and is using excel for the generation of the ticket numbers. The format of the numbers on each ticket needs to have its number displayed in the form of;

000001
000002

through to

999999

ie with leading zero's displayed... but I can't see any way to have those leading zeros displayed on the numbers 1 to 99,999. Is there a way to accomplish this in excel?

Thanks

A:Excel - how to display a number of leading zeros...

6 more replies

I'm running Windows Vista on a Dell XPS 410 desktop with Excel 2007. I need to enter numbers starting with zero in the column field and they when I leave the cell, so do those zeros. I have set that column to text and the zeros remain but as soon as other activity goes on, it appears that Excel defaults to removing those beginning zeros again and I have to change the settings each time in the number group to text or use the format painter to copy a cell where the zeros remain intact.

Is there a way of setting the defaults so that the beginning zeros remain unless I change the settings? This is a big nuissance and I assume there's an easy fix but I can 't find it.

Thanks,

Mark

A:beginning zeros disappear in Excel 2007

Yes I have the same problem in excel 2007 and never found any solution of this.

7 more replies

Is it possible to insert leading zeros into cells that already contain information. We have a spreadsheet with a colum of numbers and they vary in length. We must prepare the spreadsheet for export and that colum is required to be 8 digits long so we are required to insert leading zeros to accomplish this. None of the numbers are identicle and the difference in length varies and is inconsistent. I appreciate your help.

A:MS Excel 2007 inserting leading zeros

you can use a custom format

if you goto
format cells
custom format
enter
00000000

that should add leading zeros and keep the number length 8 digits

2 more replies

Good people ,
I was wondering If , after i wrote Zeros , to the complete Hard Disk Drive , [i have only one internal Hdd] , Via The Hard drive's Utility Disk , In order to get rid of all Acer factory bloatware , or to simply make a clean re install of windows 7 home basic , and /or maybe solve some of the problems i am having with bad sectors etc [whether it solves that problem or not ] , [my question is - WILL I be able to generally insert my Factory Recovery Disks [Perfectly working and well tested set of 3 DVD-R's with a separate DVD-R for all the drivers and applications is with me] to Install my operating system back to factory DEFAULTS After the said procedure of Zeroing out the whole drive is complete? Could i face a problem [logically] getting back to the condition i am in now , as that would be the first thing i would want to check and do as soon as the zeroing process is over [if at all i do go through with it].
I would appreciate any help /suggestions /light on this matter . And i thank you very kindly [in advance] also . Axe.

A:Installing by Recovery Disks After Writing Zeros to the Complete HDD.

I would Check the hard drive first with the manufacturer's diagnostic tools.
Hard Drive Diagnostics Tools and Utilities (Storage) - TACKtech Corp.
Hard Drive Diagnostic Procedure

8 more replies

I am needing to export a table from Access 2003 as a fixed-width. I have found where to insert the leading zeros in the date field, however, I am needing to insert leading zeros in a number field. Example: 350.00 hours needs to be exported as 0350.00

Can anyone help me? Thanks.

A:Insert leading zeros in microsoft access 2003

If you could create a new field as a text field and add the 0 at the front of the text, would that work for you?

1 more replies

Hi there,

Been having some issues with Windows Update, especially when it comes to trying to install SP1 (64 bit) on my Windows 7 Ultimate x64 machine. I've downloaded the latest (Aug. 2011) System Update Readiness tool, which has shown be that two manifests are corrupted and showing all zeros.

I've tried typical things such as resetting Windows Update, etc. however nothing has fixed it so far. I have a few friends in the house (shared student house) also on Windows 7, so thought about copying the files off their machine and replacing the corrupted ones on mine, however the files were non-existent on their machines.

Here is a copy of the CheckSUR.log file:

Code:
Binary Version 6.1.7601.21645
Package Version 13.0
2011-10-05 16:26

Checking Windows Servicing Packages

Checking Package Manifests and Catalogs

Checking Package Watchlist

Checking Component Watchlist

Checking Packages

Checking Component Store
(f) CSI Manifest All Zeros 0x00000000 winsxs\Manifests\msil_mscorlib.resources_b77a5c561934e089_6.1.7600.20935_en-us_4fdd65da8f1fc992.manifest msil_mscorlib.resources_b77a5c561934e089_6.1.7600.20935_en-us_4fdd65da8f1fc992
(f) CSI Manifest All Zeros 0x00000000 winsxs\Manifests\msil_mscorlib.resources_b77a5c561934e089_6.1.7600.16789_en-us_66afb31075744e72.manifest msil_mscorlib.resources_b77a5c561934e089_6.1.7600.16789_en-us_66afb31075744e72

Summary:
Seconds executed: 343
Found 2 errors

A:Windows Update - CSI Manifest All Zeros, msil_corlib.resources

Done a repair install/upgrade which sorted the issue.

1 more replies

Working with excel column where I have had to format cells to show leading zeros such as 00061679. When I try to print the entire number the zeroes do not print. How do I get the entire cell to print? When I click in the cell it only shows 61679.

Thanks,
Peanut

A:Solved: Excel need to print leading zeros in column

10 more replies

Looking for assistance again! Thought I would put together a small script to let me allocate random names to files and at the same time add a Prefix or a Suffix as required. However, the problem I ran into was when I wanted the suffix to include leading zeros namely, if the file name was to end ..... 1.txt I wanted to have .....0001.txt. Providing 0001 in the suffix data input box did not work despite showing as .....0001.txt on screen. The resultant file came out as 1.txt. Using a function seemed to work on a single file until I remembered that a function doesn't work in a loop! Can any of you guys out there assist and point me in the right direction?

I've added my script below. It does what I want apart from adding the leading zeros but it's a bit rickety. The files I was testing it on are named:

Library_123.txt, Library_456.txt, Library_789.txt

Thank you

Code:
Option Explicit

'Define vars
Dim fso, f, intMax, iLoop, k, intValue, strChar, strName, intNum
Dim File, strPrefix, strSuffix, Tally, x, Pad, n

Set fso=CreateObject("Scripting.FileSystemObject")

' Characters available for random choice
Const Chars = "abcdefghijklmnopqrstuvwxyz123456789"

' Specify length of names.
intMax = 40

'Input File Prefix
strPrefix = InputBox(chr(13) & chr(10) & chr(13) & chr(10) & " Enter Prefix", "Data Input")

'Check point
wscript.echo " Prefix Entered Is: " & strPrefix

A:Solved: Problem With Leading Zeros In File Names

Hi there,
Looking at your code I get lost along the way, but if the filename is to be a number then you have to make sure you also allocate is as a string.
The way I do it when I'm coding with vba is using the right() function. I came accross this when looking for some code

Let's say:

x = 3
and my filename in this case will always be 8 characters long then I do it as follows:

fname = right("00000000" & x, 8)

if x = 42

the result is 00000042

Maybe this will help to point you in th the right way.

3 more replies

I have a large Excel worksheet of binary survey data coded with "1" for YES responses and empty cells for NO responses.
I am trying to use the AVERAGE function with this data but now find that each empty cell needs to have a zero in it for the AVERAGE function to work properly.
What can I do to automatically insert a zero in each empty cell in a large range of data?

A:Excel 2000: How can I insert zeros into empty cells?

7 more replies

Dell laptop with a WD 750GB Black hard disc. Decided to do a clean install of the OS after upgrading from Windows 7 to Windows 10. I wanted to go back to 7 and start with a clean drive and used Western Digital's Data Lifeguard Diagnostics for DOS.
Wrote zeros to the drive, and then booted to my retail version of Windows 7 Pro 64 bit, only to receive an unmountable boot volume error. Ran a quick test on the disc and it came back error free. Now running the full test but it takes about 90 minutes.
In the meantime, any suggestions on what is wrong and how to correct it? Thank you.

A:Unmountable Boot Error After Writing Zeros to Disc

First make sure you have your COA key handy.

Now use this tutorial by Brink.

Clean Install Windows 7

7 more replies

I have a Dell Dimension 4500, with 1 GB RAM, CD-R/RW, 75 GB Seagate HD, FD, USB, Ethernet. I used KillDisk on it to write zeros to entire drive. I don't have any of the original disks that came with the PC. I do have an exe self-extracting file of an ISO image for XP Pro. Can anyone help give me step by step simple directions of how to use this file to install Win XP Pro as a fresh install?

A:Hard Drive all zeros, all original disks lost.

If you truly have an .iso image of XP Pro...then the first thing you need to do is burn that to CD. In it's present format, it cannot install anything on your system...but turning it into a bootable CD will allow installation.How to successfully burn or write an ISO-image to cd or dvd - http://iso.snoekonline.com/iso.htm To install XP, two things are required: You must have a valid license to install XP Pro (a license for XP Home will not do) and you must have a CD that truly has all the files necessary to intall XP Pro on a system.XP Clean Install, Stevens - http://www.michaelstevenstech.com/cleanxpinstall.html Clean Install Windows XP - http://www.theeldergeek.com/clean_installa..._windows_xp.htm Louis

6 more replies

We have an issue where Windows Desktop Search V4.0 on Windows XP SP3 doesn't search numbers with leading zeros.

For example we have documents that contain a certain reference 016-073, Windows Desktop Search also displays documents, which contain page numbers 16-73.

We don't want that, we want to be able to get exact results for 016-073. We tried advance syntax such as single and double quotation marks, but search still displays results where leading zeros are ignored.

Indexing is done on a windwos 2008 R2 server (which is also a file server) and Widnows desktop search uses the UNC path to search the file server shared folders.

I've enabled treat similar words with diacritics as different words to no avail.

I've applied hotfix Windows6.1-KB977380-x64 as well

Any suggestions?

A:Windows Desktop Search problem with leading zeros

In general, Windows search sucks.I substituted it with 3rd party free product long time ago.\I use Super Finder XT: http://freesoftland.sytes.net/ssearchxt.htmlIt has a lot of options and it....works...even with leading zeros

3 more replies

Our department receives an Excel spreadsheet with a multitude of sheets on a regular basis from another department. Some of the cells are formatted as "General" and others as "Text". One of our departments macros searches for certain instances of a number on the Logic and Flow columns such as the number "1". In doing so, the macro finds "1", "21", "102" and so on. Or if seaching for the number "20", it finds "20", "120", "201" and so forth. I would like to run a macro on each sheet that would, if need be, change all of the data in the Logic and Flow columns to Text and then add leading zeros to make each of the numbers in the cells 3 digits long. In my example, Cell B2 original has a 4 and a 2 (4 2). I want to end up with 004 and 002 (004 002). In my example, Cell B8 original has a 20AT. I want to end up with 020AT.

In my attached example, Columns B & C are what we get from the other department. I want to end up with what is shown in columns F & G.

A:Solved: Add zeros to excel cell formatted as text

16 more replies

Hi Again

CodeLexicon gave me a code that worked very well in hiding column A only. Is it possible to make the macro hide all columns with all zeros?? Also I tried to change CodeLexicon's macro to do hide all rows whose columns have zeros but without success. I tried to make the code generic.

Attached is a workbook with the 2 macros. Test the macro that I did out and see that it only hides row A only.

Mario

A:Solved: Macro to hide all rows whose columns have zeros

6 more replies

I am having a problem with my keyboard constantly inserting 0 and . in docs and forms, etc when typing. Occasionally the computer will freeze while a pop up window (such as open files in Word) will flicker.

The computer will also automatically fill in forms with 0 and/or . and send them.

I can boot up, but anything other than mouse work is difficult as any typing will start the 0 and . stuff.

Pressing ESC will stop the entrys, but it will often start up again.

I have run malwarebytes and spybot, but nothing is there.

A:Keyboard inserts zeros and periods in docs and forms

Is this a laptop or a desktop? Have you tried another keyboard?ATFPlease download ATF Cleaner by Atribune & save it to your desktop.Double-click ATF-Cleaner.exe to run the program.Under Main "Select Files to Delete" choose: Select All.Click the Empty Selected button.If you use Firefox browser click Firefox at the top and choose: Select AllClick the Empty Selected button.
If you would like to keep your saved passwords, please click No at the prompt.If you use Opera browser click Opera at the top and choose: Select AllClick the Empty Selected button.

12 more replies

Ok first of all i apologize if this question has already been addressed but I am having serious problems with my computer and it is a miracle that i was even able to make it this far.

I have Windows XP with sp2 i believe. I purchased this computer back in 2005 so its pretty old but i havent had many problems with it until recently. I didnt have internet for about 2 years so my comp was safe from viruses and whatnot. i just got internet about 2 months ago and since then my girlfriend has been downloading numerous files through frostwire, many containing viruses.

I have an 80gig hard drive that has 2 partitions. one is my C:\ drive and the other is my D:\ drive which is my recovery drive. My computer did not come with any sort of recovery disk, only the 2nd partition on my hard drive.

in the last month the computer has became practically unusable. now that i have finally given up on the computer i just want to write zeros to the C:\ partition of my hd & hope that it would allow me to load from D:\ to reinstall windows. let me mention that i have already done a system restore 2 or 3 times on this computer and it would halfway work but not like it should.

well, going through my system restoration using F8 or F1 or something like that during start up, it gives the option to look through C:\i386 or C:\windows.

about a month ago i was looking for how to do a system restore and stumbled across this screen. i chose the 2nd option which was C:\windows and it gave me a list o... Read more

A:Computer ruined. Trying to write zeros through dos. Ghost administrator wont allow.

16 more replies

In Access I have a field "Age" which is formatted as text.

I import a txt file from Excel where the Age data contains some ages and some txt such as "Staff".

7
11
Staff
24

etc.

How can I force the ages to have a leading zero so that they appear in sequence in reports?

I know if I format the Age field as Number they appear correctly sorted in reports, but then I can't use text as well in that field.

Ken

A:Importing txt file into Access text field with leading zeros

It might be simpler to modify the input data from Excel, so they are correct, or perhaps a little bit of vba code might be useful to whip through that field's data to modify those records which have a number to have leading zeros.

2 more replies

DON"T MISS OUT ON THIS OPPORTUNITY!!

Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com

More replies

Hello from No. Carolina. I surely hope someone can help with this. I renewed my Uniblue SpeedUpMyPC license last night and now every time I enter my Yahoo! e-mail user name and password I get redirected to a blank page! Suggestions?

A:I'm Counting on Y'all

Have you checked with Uniblue's support page? http://www.liutilities.com/support/

1 more replies

Hi,

Not sure if this could be done...but is it possible to make a script that would tell you the most amount of people that were online at your forum by counting the profile urls in the source code, then displaying the amount and time and date, then it would change if the number increased?

Or could there be another way of doing it?

Thanks

Peter

More replies

DON"T MISS OUT ON THIS OPPORTUNITY!!

Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com

More replies

hello i was trying to figure out how to count the number of letters in an inputted line of text and display letter by letter how many of each there were..any ideas to help thanks

A:counting

9 more replies

i posted a thread yesterday, but got no replies, i have heard this forum is great, so i hope you can help me.
im having a few problems..

1. i have constant pop ups (have had 9 since beginning this thread..10)

2. i cannot save any new files, pictures, or anything. and its important that i do, i am a marketing advertiser and i really need to be able to work with my pictures and graphics.

3. i randomly hear some sort of sports radio channel through my speakers, even with my internet browser closed. sometimes its a poker channel, sometimes its baseball, just 10 minutes ago it was a stupid "guess what candy bar your tasting" thing. the only way i can stop it is to restart my computer.

4. my task bar disappears randomly and comes back maybe 20 minutes later. (as im typing this i dont see it)

5. my computer is running extremely slow. ive never had this problem.

6. ive tried running my spybot search and destroy, adaware, and kaspersky, and all 3 of them stop in the middle of the scan saying there was an error, and my computer shuts down.
if i can get some kind of help, i would greatly appreciate it. i dont want to lose any of my programs that i have paid for. i dont want to lose anything, and i cant afford to go out and buy a new computer.

6 more replies

I have been messing with viruses and infections for 2 days and it seems like I'm spinning in mud. I have another thread:

http://forums.techguy.org/t250735.html

I have scanned with Ad-Aware 3 times and keep finding New Objects. I have HJT and posted it below. Before I started any of these procedures, I couldn't even get to the internet with being redirected, AKA Hijacked. I have since been able to at least close some windows and be able to do enough surfing to get to this forum and download some software. The problem I face now is that when I do start surfing around I get Hijacked by www.81.9.3.87/go/"whatever advertisement goes here".htm

Here are system specs:

345 MHz AMD-K6 3D processor
192 MB Ram
30 GB HD
XP PRO NTFS File System

Foloowing is the newest HJT logfile:

Logfile of HijackThis v1.98.0
Scan saved at 3:45:56 PM, on 7/16/2004
Platform: Windows XP SP1 (WinNT 5.01.2600)
MSIE: Internet Explorer v6.00 SP1 (6.00.2800.1106)

Running processes:
C:\WINDOWS\System32\smss.exe
C:\WINDOWS\system32\winlogon.exe
C:\WINDOWS\system32\services.exe
C:\WINDOWS\system32\lsass.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\System32\svchost.exe
C:\WINDOWS\system32\spoolsv.exe
C:\WINDOWS\System32\atievxx.exe
C:\WINDOWS\Explorer.EXE
C:\WINDOWS\winlogon.exe
C:\mssys.exe
C:\mssys.exe
C:\WINDOWS\sachost.exe
C:\Program Files\Messenger\msmsgs.exe
C:\Program Files\MA311 PCI Adapter Configuration Utility\wlanutil.exe
C:\WINDOWS\System32\Zso5Vyh.exe

A:2 Days and Counting ... Need Help!

16 more replies

Hello All:

All I want to do is create an Audio CD from some .mp3 files I have.
(15 .mp3 files = 55.9MB)

I have tried ImgBurn, Ashampoo Burning Studio, and BurnAware.

I have tried changing the write speeds to the lowest settings.

It all seems to go well until the end of the burn when every program tells me the Write Failed. That's it- and I don't know why.

I have an IDE Plextor DVD/RW (PX-870A ATA) drive.

Any ideas about settings? Or anything else I should be checking?

TIA!

A:4 Frisbees and Counting...

Quote: Originally Posted by rap33042

Hello All:

All I want to do is create an Audio CD from some .mp3 files I have.
(15 .mp3 files = 55.9MB)

I have tried ImgBurn, Ashampoo Burning Studio, and BurnAware.

I have tried changing the write speeds to the lowest settings.

It all seems to go well until the end of the burn when every program tells me the Write Failed. That's it- and I don't know why.

I have an IDE Plextor DVD/RW (PX-870A ATA) drive.

Any ideas about settings? Or anything else I should be checking?

TIA!

How long are those mp3 files, not in bytes but in minutes?

Things ro consider... when buring a standard audio CD, the mp3 files must first be converted wav files, the burning programs do this automatically.. at least most of them do. If the mp3s are encoded at a high bit rate the wav files could be quite large... is it possible you're exceeding the size limit for the CD?

The other thing to remember.. although it shouldn't affect the burn, use "Disk At Once".

Ap

9 more replies

Hello. I bought a used computer a few months back (app. 7-8 mos. ago), but was not hooked up to the internet until 3 weeks ago or so. I got Aol dial-up & unsuccessfully tried to download their anti-virus program, but due to an earlier installation of Norton, some files were still on hard drive, & AOL would not proceed until they were found & deleted. So the bottom line was I was so thrilled to be back on the internet that I didn't push the anti-virus program issue. My fault totally, but when I finally did run a Pc-cillin scan, I was completely shocked at the NUMBER of viruses- I was only through 1/3 of my files & it was reading 7,000 +. However, as I looked at the files being scanned I realized that I did not recognize any of them & the virus which was pre-dominant, Worm GAO, was probably on the computer when I bought it, propagating away. Anyway, I realize the hard drive is toast, but are any of the files salvageable? Could I use Pc-cillin to scan individual files & save them to CD or do I still run risks of re-infecting a new hard drive?Also, I uploaded photos to Yahoo, so if people were to download them to their computers, will they contain viruses? How about saved e-mail? And yes, I definitely learned my lesson the hard way!!! Thanks to anyone, for advice. I have Windows XP Professional. System Manufacturer VIA Technologies, Model VT82C597. AMD-K6 (tm) 3D Processor, MMX, 3D now, 500 mhz . Thank you.

A:Over 7,000 Viruses & Still Counting!!!!

12 more replies

To put it in a nutshell, I downloaded a game, tried to open it, however it never did. Now accessing my processes list... I have over 500 processes running, and counting. All under the name of the game. My laptop doesn't appear to be running noticeably slower, however these 500 processes are going to mess my computer up sooner or later..

I scanned the executable file with MalwareBytes, Kaspersky (my background AV) and Microsoft Defender. It was clean. Kaspersky however, noted that the program was potential dangerous, only because the digital signature was missing. I told Kaspersky to 'Limit' execution - only to stop dangerous actions.

I then continued to watch my process list grow up to 1000, running under my username. Then eventually, the physical memory overloaded and my computer crashed.

Several days later the same thing occurred. However this time, with a different game. I scanned it, and it was clean. I told Kapsersky to once again, limit execution with no digital signature. Within seconds of opening the game, I had over 200 processes, and the number was slowly rising. I had to hit 'End Process Tree' in order to stop my computer from crashing again.

One person suggested that it had to do with Kaspersky... As other games have worked in the past without limiting them.

I know it isn't a virus or anything malicious, perhaps a glitch? And how can I prevent it?

Windows 7
AV: Kaspersky Pure

A:500 Processes And Counting?

Try Googling the names of some of these processes. Perhaps that will help you figure out what's causing them or if they're malicious.

2 more replies

I've got to implement a function that will return the value of bit n of a binary number. I then have to implement a function that will change bit n to 1 or return a 0 if it is out of range.

I'm a bit stuck on this one, anyone know how I'd do it?

A:C++ Bit Counting Problem

C++ bitwise operators tutorial

To get what you want you should read up on bit masks and the bitwise and operator. The basic idea is to mask out the bits that you dont want by using a bitwise and operator. I can post example code if you like.

3 more replies

DON"T MISS OUT ON THIS OPPORTUNITY!!

Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com

More replies

DON"T MISS OUT ON THIS OPPORTUNITY!!

Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com

More replies

Windows 10 is coming SOON!!
If you are eligible for the free Upgrade offer you can reserve the DL for the GA. You will need W7 SP1 or W8.1
Make sure your machine or machines are clean & healthy.  Always backup, backup & backup.  Recommend making a Sys Image just prior to final release
GA-Day is July 29
Cheers,Drew
PS:  Did I mention backup?

A:T- Minus 33 & Counting

I see the first topic in the Win 10 section is dated 1st October 2014. We have had nine months of mumping and moaning about the various test releases. As well as a lot of hot air there have been a number of serious and valid points raised - the purpose of the test releases.

Another month and we can all start mumping and moaning about the final release version !

I'm chicken !  I intend waiting at least six months before I consider updating from 7 to 10, and that will be dependent on whether or not I decide to rebuild my computer.

Chris Cosgrove

3 more replies

hey everyone

i'm posting this for a friend whos computer was working fine then out of nowhere it's been getting a msg

smss.exe has encountered a problem

this system is shutting down please save all files and log off\

then a bunch of other stuff that he can't make out fast enough

then after 60 seconds the computer reboots
he's running windows XP pro sp1
512mb of ram (no specific brands)
800mhz untel cpu
40gb maxtor harddrive

sorry about being so vague he's trying to tell me by memory since hes not at the computer itself for the night and we can't just reformat because there is important university essasys/reports/lectures that he can not get again

~Allen

A:counting down then restarting out of nowhere

9 more replies

Well, I've done everything I know, including your suggestions before making HijackThis log. Still getting advert popup from everything from insurance to dating. Here is my HJT log.
PS - if I post something wrong, please don't yell at me too much. It's my 1st time!

A:Counting on you guys!

Logfile of HijackThis v1.99.1
Scan saved at 12:10:23 PM, on 10/26/2006
Platform: Windows XP SP2 (WinNT 5.01.2600)
MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180)

Running processes:
C:\WINDOWS\System32\smss.exe
C:\WINDOWS\system32\winlogon.exe
C:\WINDOWS\system32\services.exe
C:\WINDOWS\system32\lsass.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\System32\svchost.exe
C:\WINDOWS\system32\spoolsv.exe
C:\WINDOWS\Explorer.EXE
C:\Program Files\CA\eTrust EZ Armor\eTrust EZ Antivirus\ISafe.exe
C:\Program Files\ewido anti-spyware 4.0\guard.exe
C:\WINDOWS\system32\nvsvc32.exe
C:\WINDOWS\System32\svchost.exe
C:\Program Files\The Cleaner\tcm.exe
C:\Program Files\The Cleaner\tca.exe
C:\Program Files\Java\jre1.5.0_06\bin\jusched.exe
C:\WINDOWS\SOUNDMAN.EXE
C:\Program Files\CA\eTrust EZ Armor\eTrust EZ Antivirus\CAVRID.exe
C:\Program Files\CA\eTrust EZ Armor\eTrust EZ Antivirus\CAVTray.exe
C:\Program Files\Weather Pulse\weatherpulse.exe
C:\Program Files\Internet Explorer\iexplore.exe
c:\progra~1\intern~1\iexplore.exe
C:\Program Files\FireTrust\MailWasher Pro\MailWasher.exe
C:\Program Files\SpywareGuard\sgmain.exe
C:\Program Files\SpywareGuard\sgbhp.exe
C:\WINDOWS\system32\wuauclt.exe
C:\Program Files\Internet Explorer\iexplore.exe
C:\HijackThis\HijackThis.exe

R1 - HKCU\Software\Microsoft\Internet Explorer\Main,Default_Page_URL = http://www.foxnews.com/

3 more replies

Hi,

I have a class called colouruser that changes the link colour of certain member's names. These names only appear in 1 table but mixed with other members names that don't have that class. How can I count the amount of members that has the class="colouruser". The class is in the A tag...

<a href="member url" class="colouruser">name</a>

Thanks

A:counting class

This should do it.

http://www.faqts.com/knowledge_base/view.phtml/aid/2193/fid/128

1 more replies

my Xp is behaving like a couple of bunnies. it was 53 , then 56 now 64
processes operating that i am not sure of. reid (of the forum)looked
at the 56 hjt log and said everything was legiit however my pc runs too slow. it takes 2 minutes after you click on something for a response

dont know what to do

glenn

A:64 processes and counting- help!!!!

What are your system specs? PC Brand and model number, OS, cpu, amount of memory?
Also, do you have alot of icons in your task bar next to clock in the lower right hand corner of your monitor? If so, you can disable the ones you don't need running and that'll free up some resources.
Defragmenting your hard drive my also help speed things up.
To start off post your system specs and a list of items that running in the task bar.

17 more replies

Howdy,

I have an Excel document with hundreds of values all with leading zeros.
The number of zeros varies from cell to cell, and the cell lengths may vary, so I might have something like:

00000123
000000012004
00555555
00000000000000ABC
00DEFGHIJ

I need to remove the leading zeros from all cells.
I can't multiply by the values by 1, because of the non-numeric entries.
I can't Replace All zeros, cos it would replace any zeros that appear within the codes, not just the leading ones.
I can't do a Replace All searching for * then a specific character, because the first char of the code is not specific.

So I'm thinking I need to do something like:
=RIGHT(A1, FIND(<>"0",A1,1)-x)
Obviously that doesn't work, cos it doesn't like the <>"0" part, and I can't put a set number in place of the "x" at the end as the number of characters to return differs from cell to cell.

Or maybe use the SUBSTITUTE function somehow, though again I still need to tell it to stop when it hits a char other than zero, as =SUBSTITUTE(A1,"0","") applied to line 2 in my example data above would return 124 instead of 12004.

Thanks!

A:Solved: Excel - remove leading zeros (differing numbers) in Text cells

Hi Gram. I checked ASAP Utilities but couldn't see this covered.

Sub Macro1()
For Each Cell In Selection
x = Cell
If Left(x, 1) = 0 Then
Do Until Left(x, 1) <> 0
x = Right(x, Len(x) - 1)
Loop
End If
Cell.Offset(, 1) = x
Next Cell
End Sub

2 more replies

I have a valid IPv6 address on my Windows 7 PC, and when I do a wireshark, I can see that TCP packets destined to my PC are not responded to when there are padded bytes to the
end of the ethernet frame. When the padded bytes are removed, the TCP session establishes normally.

<o:p></o:p>
I've tested this scenario against an Linux Ubuntu LTS 14.04, and I do not see any anomalies with padded frames.<o:p></o:p>
I have a specific reason for adding the extra bytes to the end of the frame, but as I understand the extra zeros to the end of the frame should be ignored. The added
bytes work just fine with IPv4.<o:p></o:p>

The wiresharks I have are taken on the Windows PC that seems
to be having issues. The SYN ACK is received by the PC, however beyond this it just gets dropped. The  ACK is never sent in reply.

Using the netsh command set, i've found the counter associated with these packets, but I dont know what it tells me,

C:\Users\speedtest>netsh interface ipv6 show tcpstats

MIB-II TCP Statistics
------------------------------------------------------
Timeout Algorithm: Van Jacobson's Algorithm
Minimum Timeout: 10
Maximum Timeout: 4294967295
Maximum Connections: Dynamic
Active Opens: 7029
Passive Opens: 131
Attempts Failed: 5330
Established Resets: 762

More replies

Hey all;

Working a mail merge issue in Word 2010 with the data list in Excel 2010. We have a column of truck numbers in one column that fills to a field in the mail merge. The numbers are formatted as 81112, for example. When we have one truck number as shown there is no problem. We have some contractors, however, with more than one truck so the cell contains several truck numbers as, 81112 & 81032 & 82044. When we run the merge the field in the word doc shows a zero. I can't seem to figure a formatting solution to get all three truck numbers to show in the field.

Any help or direction is appreciated.

Thanks.

A:[SOLVED] Mail Merge runs zeros in certain number fields instead of numbers from list.

Hi mduffel,

The problem is caused by the mixture of numbers and text in the same column (anything string containing non-digits is not a 'real' number). When evaluating a datasource for mailmerge, Word queries the first 10-15 rows to determine the type. If the data are all/primarily numeric, the mailmerge will evaluate any non-numeric field as 0. A workaround is to ensure the first few rows have non-numeric data, either by inserting some dummy data rows, or by ordering the data accordingly.

7 more replies

Counting the number of particular process,

I couldn?t figure out if there is a way to count the number of particular process. For example, in the attached screenshot, the number of ?ArcSoc.exe? is three.

Is there a way to count them automatically?

Thank you

Best

Jamal

A:Counting the number of particular process,

You could click on the name column to sort processes by ascending/descending order. From the looks of things, your system is set up to sort based on disk activity right now.

7 more replies

Hello,

I recently put a workstation together and am expeirencing the memory counter checking/testing/counting the memory 5 or more times. Sometimes its only three, tonight it was five or six...

The board is an MSI 6368 ver2.1

The BIOS is Award Modular W6368MS Ver 3.1 051501 Pentium 3 1000 Mhz 133 x 7.5 512mb of pc133 generic memory [IBM]

The power supply is 250 watt, and is running Windows Advanced Server, why? I dont know... practise ... lol.. anyways...

It gives me the option "esc" to skip memory test then boot.

I would like to know how to set this counter so it is not counting the memory more than once at boot up.

Thank You

Eli

A:keeps counting memory at boot-up

Enable "Quick power on self test" in BIOS

3 more replies