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 strongm 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. jmuscat

    Scientific format in exported data from SAP

    We are running SAP version 640, and Excel 2007. Since upgrading to Excel 2007 when exporting data (not saving to file) the data is in scientific format in excel. Any help would be appreciated JMuscat
  2. jmuscat

    Excel problem with parenthesis

    thanks for the reply, i have exported from pronto into access, to run a catt i have imported the data into excel. after numerous searching i have have the answer to the problem, the delimiter was an comma, this was causing the parenthesis. I have replaced these and now all is ok many thanks
  3. jmuscat

    Excel problem with parenthesis

    I have a large amnount of data exported from a program called pronto. When I import this into SAP from Excel I get an " in front and at the end of the text string. I have tried find/replace to exclude this but still happens. Any ideas
  4. jmuscat

    Excel Macro

    Basically the cells contain random numbers anything from 856 to 1245634. In some instances, not all, I need to add an extra zero at the front of the number. The only common factor would be that all the numbers reside in column A. Many thanks
  5. jmuscat

    excel macro

    waynerenaud Many thanks for your quick response, but ideally I would like a macro so that I am able to run this on various spreadsheets. A star for your time
  6. jmuscat

    excel macro

    I am wanting to create a macro that will add a zero to the front of certain cell numbers. I cannot seem to work it out. Say column A has 856, I need a macro to change it to 0856, but also use the macro on other values in other cells. Any ideas
  7. jmuscat

    Excel Macro

    I am wanting to create a macro that will add a zero to the front of certain cell numbers. I cannot seem to work it out. Say column A has 856, I need a macro to change it to 0856, but also use the macro on other values in other cells. Any ideas
  8. jmuscat

    PSTFile Shows No Data

    Use the File => Import to import to pst file into the new outlook
  9. jmuscat

    Powerpoint problem - graphics

    Go to View and check that Black and White is not checked, and that Slide Miniature is not checked
  10. jmuscat

    macro question

    I want a macro to find a specific word say in column A,then pick up the amount of the next column (b) of the same row and return the amount to another column say H. The problem is that the place where I want the amount to go will always change, but would be at the next available blank row in...
  11. jmuscat

    Excel Macro

    irstuff many thanks for the quick response, definitely saved a lot of work for my users. A star for your time and effort.
  12. jmuscat

    Excel Macro

    I am recording and writing a macro to format an imported data file into excel for users. What I am having trouble is, I need code to loop down a rows containing data, find the first blank row and then delete the next ten rows. Can someone help me with the code. jmuscat
  13. jmuscat

    Employee tracking template from Microsoft

    Open the text file in Excel and follow the wizard choosing delimited and what type of delimiter i.e. space. If the list of names appears in one column, highlight the column and from the main menu select Text to Columns. Copy into existing template. Hope this helps. JMuscat
  14. jmuscat

    Convert text to numbers in Excel 2000

    Many thanks for the quick response, I was obviously having a brain snap today. Tried the same as above but forgot to reformat formula cell to numbers.
  15. jmuscat

    Convert text to numbers in Excel 2000

    I have a large spreadsheet of data imported from SAP. I am now attempting to do a vlookup against this data with another spreadsheet. The problem is my customer number column is reading as Text, so that I cannot successly sort in proper ascending order, ergo my vlookup is not working correctly...
  16. jmuscat

    Formatting a highlighted selection affects document

    This is an issue that some of my users were experiencing. At some stage they had changed/formatted the style, and placed a tick in the checkbox, automatically update (Format => Style => Modify). When this box was unchecked the problem disappeared. Hope this helps.
  17. jmuscat

    Excel Macro Available When Opening Excel

    Katy You could also create a new dropdown menu say named Macros, and place your macro there for easy access.
  18. jmuscat

    help with vba code

    Seeing as it is Sunday night for you guys, I have given a star each for the dedication. JMuscat
  19. jmuscat

    help with vba code

    I am still a novice with vba, and I have created an excel workbox with macros to automate some functions. Now I would like to add code to the macro, so that when the workbox is opened, it will execute the macro instead of having a macro button on the spreadsheet. Could someone help me with the...
  20. jmuscat

    Permission on Mailbox

    Again Tek-tips to the rescue, many thanks JMuscat

Part and Inventory Search

Back
Top