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!

  • Congratulations TouchToneTommy 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: *

  1. WingandaPrayer

    Excel - remove duplicate commas in a cell

    Hi all, I'm looking to take out the commas from a cell except for the first instance? I couldn't find anything via the keyword search. e.g. 10, Downing Street, London, SW1A 2AA to 10, Downing Street London SW1A 2AA Many thanks.
  2. WingandaPrayer

    Outlook Calendar - importing appointments from Excel

    When using the import option from within Outlook 2003 to load appointments from Excel is it possible to automatically email the required attendees? I've mapped rhe following fields; Date, start and end times, subject, description and also added in the email addresses to the required attendees...
  3. WingandaPrayer

    Sheet tabs in excel

    Hi, Is it possible to lock just the sheet tab in a worksheet to stop someone else renaming? Many thanks.
  4. WingandaPrayer

    Numneric to Text from a merge field

    Hi all, When using Word 2003 to mail merge, is it possible to automatically change a numeric field to Text? The merge field comes from a Progress program and not excel. Thanks in advance
  5. WingandaPrayer

    Mail merge with formulas

    Hi all, If you would give me some advice please. I'm mail merging from a Progress program into Word. I was using the word field IF option when a merge field was 'not blank' the £ symbol would be placed before the field. When the field was blank it obviously wouldn't show and the next line...
  6. WingandaPrayer

    Filtering in Excel

    Hi all, When filtering in Excel the drop down arrow shows blue if the filter is in use. When not in use the arrow shows black. Is there a way to change this colour. I've altered various parts of the appearance which didn't work. thanks
  7. WingandaPrayer

    Excel worksheet last modifed

    Hi, How do I show in a cell the last date and time a individual worksheet was updated ? thanks Seasons greetings
  8. WingandaPrayer

    Sub Menu of a sub menu

    Hi, I would like to create another menu from the sub menu. Any helpful advice would be appreciated. cheers This is what I have at the present if it makes sense![sadeyes] menu_index.js oCMenu.makeMenu('sub01','top0','Lettings and Tenancies','FL_priorities.htm')...
  9. WingandaPrayer

    Screen prints in Word

    Hi, Is it possible to capture print screens showing a drop down sub-menu. The main menu is okay using ALT,CNTL,PRINT SCREEN. The sub menu disappears using ALT. I'm having to crop the picture at present. thanks Word 2000 Windows 2000
  10. WingandaPrayer

    Removing headers/footers in memo style

    Is it possible to remove to , from subject etc when printing an email. thanks
  11. WingandaPrayer

    ? dohtml

    Hi, On a previous website which used html i could use before and after to space out columns as i had set them. The current site uses something called dohtml. no longer works.All words are seperated by one space only and not lined up as i set them. Is there a simple format to replace as i...
  12. WingandaPrayer

    Out of Office Reply-Outlook (Office2000)

    Here goes the explanation. We have access at work to a public folder. I have access as an owner. How would i place an automated reply onto this folder only. Out of office assistant only works on my email address. Thanks for any help. Cheers David
  13. WingandaPrayer

    Start Up/Close down

    Hi all, I have a excel spreadsheet which opens on the start up routine. Is it possible to have this file open up(whether i have updated or not) before the closing down process completes.It's a reminder to check if i need to add more details to this one file. I don't suppose it is possible but...
  14. WingandaPrayer

    Red crosses instead of gifs

    It doesn't happen on every site but many of them only show the red cross in the box instead of the .gif I've used the repair option. Any help appreciated. Thanks
  15. WingandaPrayer

    Union query............i think

    I have 3 queries I would like to link into one. R2000 R2001 R2002 Each has two fields NameofItem.........items are unique to each query MaxofItemsused Thanks
  16. WingandaPrayer

    Dates in Word

    A simple question I hope. Is it possible to show the date as 8th November 2002. The th,rd,st etc are not set in the date formats. Thanks.
  17. WingandaPrayer

    Excel format ...../...../......

    Hi all, just wondering how to set a date with 10/10/2002 without having to enter / / thanks
  18. WingandaPrayer

    (Excel) A1 = A1+B1

    Afternoon, I quick question please. As in the heading, how do I create the following using auto calc rather than manual (F9) Cell A1 = a1+b1 add 5 to b1 and a1 becomes 5 change b1 to 7 and a1 becomes 12 Cheers
  19. WingandaPrayer

    Outlook 2000 attachments

    Morning all, Is it possible to send an email to say 5 addresses but only attach a file to 3 of the addresses. Yes is a much better reply than No....[smile] thanks
  20. WingandaPrayer

    Excel......conditional formatting or range

    Hi everyone. What I am trying to do,without sucess, is have a list in one column and when one of the items appears from the list in another cell I would like to shade that cell. e.g. using numbers List of numbers 1,17,25 In cell A1 is 18.....cell doesn't change In cell A2 is 17.....cell to...

Part and Inventory Search

Back
Top