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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Hasit

  1. Hasit

    Powerpoint

    Couple of questions: what version of powerpoint and to confirm, you want to allow users of the pp file to print the slide they are looking at if they want to print it or t print the entire deck?
  2. Hasit

    How do I convert a "General" format date string into a date?

    macropod - nice. I tried your code for giggles, and it works a treat. Thanks for taking the time.
  3. Hasit

    How do I convert a "General" format date string into a date?

    Glenn - its been about 18 months since I have seriously used Excel (change in job etc). And like riding a bike, its slowly coming back. You are correct. I was being a complete idiot with regards to Text to Columns. I was not only using the wrong options (i.e. not stripping out the time based...
  4. Hasit

    How do I convert a "General" format date string into a date?

    One more thing, which I know will make a difference. When I perform the =LEFT process on the date format I mention in my last post, the date gets converted to a serial number, so 02/12/2008 06:58:01 is converted to 39784.2902. Its on the serial number that I perform the various things I have...
  5. Hasit

    How do I convert a "General" format date string into a date?

    Good idea. Tried the LEN and 8. Which makes sense, because I used =LEFT(del_ref,8). Now, I didn't mention this before, for fear of complicating things, but my first issue, I have resolved, by copying and pasting special just the value. Then performing the text to column process and using MDY, I...
  6. Hasit

    How do I convert a "General" format date string into a date?

    doh! Sorry Glenn, you are right. Typo, I should have said MDY is the format I use, but still no joy.
  7. Hasit

    How do I convert a "General" format date string into a date?

    In step 3, I specify DATE with DMY as the format. No difference.
  8. Hasit

    How do I convert a "General" format date string into a date?

    Glenn - tried that. Stripped off the time and then went through the Text to column process. Get the same result. The date remains in General format (and in US format) woth no change - i.e. I get 4/19/07 after going through the process.
  9. Hasit

    How do I convert a "General" format date string into a date?

    By using the Text to column function (sorry, I should have stated that).
  10. Hasit

    How do I convert a "General" format date string into a date?

    Its from the Remedy system (manage problem and incident tickets). There is a function in Remedy that allows you to dump to .csv. Even if I force the format during import, it comes in as "General".
  11. Hasit

    How do I convert a "General" format date string into a date?

    Yes - its the old "Date" management problem. I used to be quite good at excel, but this one has me stumped. The situation is this: Some data has been imported and the date column has come in as a string in "General" format. The string is: 4/19/07 8:14:14 PM I don't need the time, so I used...
  12. Hasit

    How to include slide number on handout?

    Check your slide master to ensure that there are no graphics or text boxes obscuring the page number.
  13. Hasit

    Can I convert a .PPS to a .PPT?

    Actually, its even easier than that. Simply rename the file with the extension .ppt. No need to open and resave.
  14. Hasit

    MS Word Issue

    Err....thanks for that.
  15. Hasit

    Office 2007/Vista, can't find document I am looking right at?!?

    This might help : http://support.microsoft.com/default.aspx/kb/927387

Part and Inventory Search

Back
Top