Recent content by jwillard

GOT IT!!!!! Thanks so much to you all..... [2thumbsup] Boycott Sony

Im very close. If I put a 1 in a cell by itself and then drag down to fill cells below, how can I make it count 1 2 3 and so on instead of it just putting a 1 in all the cells. Hope i explained what I want there clearly... Boycott Sony

The only one thats not a constant would be the number 1 in the beginning. That would need to count by 1 as I go down the sheet. Bluedragon and anotherhiggins - Both seem to work except for my failing to mention the above variable about the first column counting. Thanks again for all the...

Thanks for the quick replies. Yes it is Excel I am using. Tony, The first one always shows the formula and not the results. The second one does not put the double quotes around the info. This is what I got with the 2nd one chrysler plymouth,103aca,,,,,,,,,,,,,,,$0.00,,,0 Very close all I...

I am trying to modify 2 fields (Customer name, customer number) that are shown below and add some text also. AUTO SALON FIN363 I need the output to look like 1,,"auto salon","fin363",,,,,,,,,,,,,,,$0.00,,,0 Note that the numbers, quotes, and commas must all be added. I have tried using...

Thanks for the replies. I will try over the next couple of days.... Boycott Sony

Thanks for the replies. I did look at FAQ183-3324 but noticed that all or most seem to be SQL2000 and the post itself is from 2003. With 2005 having been out for a while now, I thought they may be more updated books. Boycott Sony

Can anyone recommend any good books for someone looking to learn SQL. Thanks, Boycott Sony

Does anyone know of a way this can be done? We have a remote server with 2005 but I only have 2000 locally and I want to work on the data locally...... Boycott Sony

AnotherHiggins, If you have time to answer, I am curious.... I just used the formula that you gave me again - =Text(A1,"@") - and I was wondering how does the @ sign do this. I see no reference to the @ sign in the Excel help files. Also what exactly is the @ sign doing? Is it just inserting...

Nice thought Linney. thanks Boycott Sony

Well I actually meant a .reg file that I could keep on my desktop to clear that value when I wanted. For anyone else who may want to know it goes like this. Windows Registry Editor Version 5.00 [HKEY_CURRENT_USER\something\something\something\IsoDoc] "VolumeLabelISOTemplate"="" Thanks for...

Is it possible to edit an individual string value in the registry with a batch file? If so how do I do it. Any help is greatly appreciated.... Example: NAME TYPE_SZ data VolumeLabelISOTemplate Reg ThisNeedsToBEChanged NAME TYPE_SZ data...

Thank you AnotherHiggins. Your option 1 worked great. Appreciated the help from everyone. Boycott Sony

Thats a good idea but that leads me too, how do I pull everything from the dash over to another column. Excuse my ignorance but im kind of a newby to formulas. Boycott Sony