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 derfloh 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: Hasit
  • Order by date
  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
  16. Hasit

    Outlook 2003 - bcc limit?

    Depends on your email service provider. See here: http://office.microsoft.com/en-us/outlook/HA012002371033.aspx
  17. Hasit

    Sheet Protection and Circular Reference!!!!!

    Make the formulas absolute references (unless you need something else). So if a formula reads =A1+B1 absolute references would turn it to =$A$1+$B$1
  18. Hasit

    COUNTIF formula to return dates within week

    Whats the format of your dates? Are they split up by any means? e.g. week, month etc?
  19. Hasit

    Can you count shaded cells?

    John has pretty much given you the answer. For some worked examples, see http://www.cpearson.com/excel/colors.htm
  20. Hasit

    Increasing number of arguments in an IF statement

    Each cell would need its own formula for different cell entries (K4, K5, K6 etc), so why not drag down the forumla ensuring that the ranges are absolute entries (by adding "$" symbols in front of the letters and cell numbers)...

Part and Inventory Search

Back
Top