+ Reply to Thread
Results 1 to 2 of 2

How do I convert a word table into an excel document?

  1. #1
    Aaron
    Guest

    How do I convert a word table into an excel document?

    I have managed to get the info accross no problem but the formatting is all
    over the place. For instance - 07/10 meaning July 2010 is appearing as 07/Oct
    despite me going into format cells custom then enter mm/yy which has always
    worked previously.

    Any ideas?

  2. #2
    Peo Sjoblom
    Guest

    Re: How do I convert a word table into an excel document?

    You can't use it like that regardless of formatting, you need to put in the
    whole date or else Excel will always assume the current year so any real
    date used for calculations needs to be numeric and needs a day, so you can
    enter (assuming US date format) 07/01/10 and use a custom format of mm/yy

    or if you don't need it for calculations just precede it with an apostrophe
    or preformat cell(s) as text and just enter it as '07/10 (apostrophe won't
    show in cell) or if text formatted 07/10

    --

    Regards,

    Peo Sjoblom

    "Aaron" <Aaron@discussions.microsoft.com> wrote in message
    news:87851135-4062-45BC-BEC1-E5ECDAFDB4C2@microsoft.com...
    > I have managed to get the info accross no problem but the formatting is

    all
    > over the place. For instance - 07/10 meaning July 2010 is appearing as

    07/Oct
    > despite me going into format cells custom then enter mm/yy which has

    always
    > worked previously.
    >
    > Any ideas?




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1