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 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
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...
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...
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
I need to sort Part numbers with mixed numbers and text.
Any help would be greatly appreciated.
Currently the data sorts as follows
200
203
205
207
310
315
330
336
340
345
350
225-2T
250-2T
260-2T
270-2T
275-2T
300-2T
305-2T
306-2T
310-2T
Needed Result:
200
203
205
207
225-2T
250-2T
260-2T...
You can try this and see if it helps...
1. On the Tools menu, click Options, and then click the Print tab.
2. Click to select the Background colors and images check box, and then click OK.
Boycott Sony
I have been in touch with CA support. they had me delete the database and add an empty one. So far all is good. I have been able to edit jobs.
Thank for the help
Boycott Sony
PAPushka, I did try your solution. No Help....
VSChumpy,
I am running Windows Server 2003. It is fully patched to date and IE is also fully patched.
Win - SP1
IE - 6.0.3790.1830
It was working fine for a long time before. I think the last patch tuesdays updates may have caused this because...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.