Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: bnc123
  • Order by date
  1. bnc123

    Format Time As You Type - MS Excel

    Thanks Loomah, But it only works on a brand new workbook (or worksheet). I tried to work it in one of my existing workbooks which already has about 25 worksheets and it does not work. Anything I should know? Hope I am not taking up too much of your time, but I simply don't know how VB works.
  2. bnc123

    Format Time As You Type - MS Excel

    I have formatted certain cells of my spreadsheet to indicate time in the format hh:mm using the custom cell formattihg option. With this method, everytime I enter a time say 19:30, I have to insert a colon using the shift key and all. Is there a way by which I can simply type in the four...
  3. bnc123

    Format Time As You Type - MS Excel

    I have formatted certain cells of my spreadsheet to indicate time in the format hh:mm using the custom cell formattihg option. With this method, everytime I enter a time say 19:30, I have to insert a colon using the shift key and all. Is there a way by which I can simply type in the four...
  4. bnc123

    Incremental number in Excel

    Thanks Brad, It worked. Ofcourse I'll have to go through your explanation a few times before I can get a grasp on it, but the imnportant thing is that it worked for now. Thanks again and have a nice day.
  5. bnc123

    Incremental number in Excel

    Well Brad, I am not a very advanced Excel user. So, I replaced 'filename' with the actual filename, 'Sheet' with 'Sheet1' and 'A1' with 'D5' in your suggestion above and pasted it on Sheet2 of my workbook. Nothing happened. Infact the cell turned into '#value'. So, can you please be a bit...
  6. bnc123

    Incremental number in Excel

    I have 10 sheets in my Excel workbook. In cell D5 on sheet1, I have the number 1. If I want that number to increase by 1 in cell D5 on sheet2, what formular should I use in cell D5 in sheet2? The obvious answer would be: =Sheet1!D5+1 But if I copy that formula on to sheet3, cell D5 on...
  7. bnc123

    Gradient Background for Web Page

    So this gradient script, can it be worked only with the BODY tag or can it also be worked with other tags e.g. TABLE tag. I tried to give a table a gradient background using this script, but did not succeed. Any hints?
  8. bnc123

    Gradient Background for Web Page

    ...= document.createElement('div')); aDiv.style.height = bandHeight + 'px'; aDiv.style.top = (bandHeight * bandLoop) + 'px'; aDiv.style.backgroundColor = 'rgb(' + colourSteps[bandLoop][0] + ',' + colourSteps[bandLoop][1] + ',' +...
  9. bnc123

    Search for a file - Excel

    I have a directory full of Excel files. All the files are of the same format. I want to look for a file (spreadsheet) that has the number (not text) 9.543 in cell D10. Is there a search utility that allows me to do something like that? I can't seem to do it with conventional search utilities.
  10. bnc123

    Gradient Background for Web Page

    Thanks Dan, I took your script and converted into a simple two colour gradient. Have a nice day.
  11. bnc123

    Gradient Background for Web Page

    I would like my web page to have a gradient background. Now I did a search and came up with the famous Background Fader Script. However, this script has an animation between many colours. What I want is a simple steady gradient between two colours. No animation, no fancy stuff. I can't seem to...
  12. bnc123

    Protection of Word Document

    Thanks Tony, I see it now. Regards.
  13. bnc123

    Protection of Word Document

    In MS Office 97, I could protect one section of the Word Document, while leaving the other section free to be edited. I am ofcourse talking about protection for forms. In MS Word 2003, they have changed the complete dialogue box for protection and I cannot find any way that I can protect one...
  14. bnc123

    Wrap Text in Excel Cell

    Thanks Skip, It worked. Have a nice day.
  15. bnc123

    Wrap Text in Excel Cell

    I have formatted a few cells in my spreadsheet to wrap the text within them. My question is: Is it possible to break lines (like make paragraphs) in that cell? Or do I have to make do with one paragraph.
  16. bnc123

    Recognise Valid Numbers Only

    Many Thanks macropod. It worked. You have just saved the day. Best Regards.
  17. bnc123

    Recognise Valid Numbers Only

    Thanks macropod, it did work. Now what do I do if I want to add the same cells as: =A1+A2+A3+A4+A5. What do I do then? I tried to use =(IF(ISERROR(A1+A2+A3+A4+A5),0,A1+A2+A3+A4+A5)) but it didn't work. This is the way I really want to do it. I think I asked the wrong question in the first...
  18. bnc123

    Recognise Valid Numbers Only

    I have some numbers and some uncalculated formulas as follows: A1: 123 A2: 567 A3: #VALUE! A4: 856 A5: #DIV/0! Now, I want to add them all up by using the sum formula =SUM(A1:A5) but I want to add only the valid numbers (123, 567 and 856) and ignore the uncalculated formulas (#VALUE! and...
  19. bnc123

    Splitting Names

    I don't know about you guys, but if the middle name was blank, I would have forced a middle name with something really wierd like "555abc" and then gone with the original code. When the time came to read the data, the "555abc" could be replaced with "". Very amateurish, but a heck of a lot...
  20. bnc123

    Remove Carriege Returns

    Well, I tried lots of combinations and here is what worked atlast: $text =~ s/(\r\n)+$//; $text =~ s/\n/<br>/g; $text =~ s/\r//g; The first line did not do it by itself, the first and second lines did not do it by themselves. I had to introduce the third line to get it working. Thanks...

Part and Inventory Search

Back
Top