If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word should catalog misspelled words to study. | rndthought | General Discussion | 38 | January 23rd, 2008 11:53 PM |
Hebrew Suggestions | Dannyza | General Discussion | 2 | November 21st, 2005 06:12 AM |
Word 97 in Windows XP to maintain formatting | Charlie''s Word VBA questions | General Discussion | 21 | October 24th, 2005 09:49 PM |
Can Wordperfect templates be converted to Word template docs | Terrill | New Users | 2 | September 14th, 2005 09:14 PM |
Excel worksheet in Word linked text boxes | Eduardo Oliveira | Page Layout | 0 | January 5th, 2005 11:23 PM |