It should've but I'm sure it went long enough to where someone understood we were not talking about word. This isn't the first time where a thread was hijacked, but I see your point, sir... Also, who knows, maybe we motivated Danny or whomever the original poster of the thread was to use excel even if it is a pain in the arce application at times. Lol.
-----Original Message----- From: ratshtron [mailto:[email protected]] Sent: Sunday, January 3, 2016 7:11 PM To: [email protected] Subject: Re: Creating column of dates in excel 2013. Ok, got it! but the subject should have been changed to 'creating columns in excel' Legend has it that on Sunday 1/3/2016 06:33 PM, Dale Alton said: ---------------------------------------- >Yea!!!!! Happy to hear success. > > >Denver Dale > >From: Kimsan [mailto:[email protected]] >Sent: Sunday, January 03, 2016 5:25 PM >To: [email protected] >Subject: Re: Creating column of dates in Word 2013. Ok, got it! > >Never mind my last email, I got it. I had to widen the columns. I felt >stupid after writing that last message. >What I am trying to do which is why I poked my head in this thread to >begin with is do a time sheet for work but not have to manually type >the dang date each day which isn’t hard when I can just hit CTRL >semicolon. >But, now I need to figure out how to have it ignore the weekend, which >I think I just need to set it to week days. Lets try that. >From: Dale Alton [mailto:[email protected]] >Sent: Sunday, January 3, 2016 3:46 PM >To: [email protected] >Subject: Re: Creating column of dates in Word 2013 > >Don't change the step value. Let it remain at 1 in step 6. > >Denver Dale > >From: Kimsan >[<mailto:[email protected]>mailto:[email protected]] >Sent: Sunday, January 03, 2016 3:27 PM >To: <mailto:[email protected]>[email protected] >Subject: Re: Creating column of dates in Word 2013 > >I will try it again, but I will write as I am doing it. > >1. Launch excel >2. For A1, through a4, I will put ¼, 1/5, 1/6 and 1/7. >3. I will select A1 through a4 and evoke the keytip alt h f I s. >4. I am in the series dialog, so let me review what is selected in the >radio buttons. >5. Collumns, date and day. >6. Where I thought it said start value, it actually says step value. I >have terrible hearing, sorry. I put 1/4 there and put no stop value.. >The trend checkbox is unchecked and I tab to ok and press spacebar. >Now, you would think in a5, it should say 1/8 right? It doesn’t say nothing. > > >From: Dale Alton >[<mailto:[email protected]>mailto:[email protected]] >Sent: Sunday, January 3, 2016 2:10 PM >To: <mailto:[email protected]>[email protected] >Subject: Re: Creating column of dates in Word 2013 > >I used your example and put 1/4then selected the cells. > >Denver Dale > >From: Kimsan [<mailto:[email protected]>mailto:[email protected]] >Sent: Sunday, January 03, 2016 1:43 PM >To: <mailto:[email protected]>[email protected] >Subject: Re: Creating column of dates in Word 2013 > >What do you put for the start value. > >From: Dale Alton >[<mailto:[email protected]>mailto:[email protected]] >Sent: Sunday, January 3, 2016 5:46 AM >To: <mailto:[email protected]>[email protected] >Subject: Re: Creating column of dates in Word 2013 > >The only thing I don't do is put in an >endvalue. I select the columns or rows that I >need to get the desired effect and then run the >fill, i.e. a1:a31 or a1:ae31. hth > >Denver Dale > >From: Kimsan [<mailto:[email protected]>mailto:[email protected]] >Sent: Saturday, January 02, 2016 9:08 PM >To: <mailto:[email protected]>[email protected] >Subject: Re: Creating column of dates in Word 2013 > >I tried that last night putting ¼ in A1, 1/5 in a2, and finished at a4. > >Then I selected the rows with the dates I just >wrote, did alt h f I s and it put me in the >start value, which I put 1 to increase by 1 day, >then the stop value, I put 30, for 30 days. >Nothing happened. Did I do it wrong? Or something wrong? >From: Dale Alton >[<mailto:[email protected]>mailto:[email protected]] >Sent: Thursday, December 31, 2015 8:55 PM >To: <mailto:[email protected]>[email protected] >Subject: Re: Creating column of dates in Word 2013 > >Hi, >This is how I would do it. > >Start 3 in a row for example 1/1/201, 1/8/2016, >and 1/15/2016. Then highlight the number of >rows or columns that you want the series to go >on. For example a1:a52. Once that is done do >an alt+h, f, I, s. This will put you into the >fill area and into series. When I tested it the >information was already there for every 7 days >and I tabbed down to ok. I hope this helps. > > >Denver Dale > >From: Mike B. [<mailto:[email protected]>mailto:[email protected]] >Sent: Thursday, December 31, 2015 2:55 PM >To: <mailto:[email protected]>[email protected] >Subject: Creating column of dates in Word 2013 > >Hi All, > >Posting this for someone else hoping someone can help him: > >From: <mailto:[email protected]>Danney Yates >Trying to create a running column of dates edit; typed in Friday >January 1, 2016 and hit enter, hoping that Word would just insert the >next date, etc but it will not. I've searched menus and cannot locate a >way to do this. >Isn't this possible, rather than my having to type all these dates manually? >Thanks for any help ! >Danney Yates > ---------------------------------------- <http://www.sendspace.com/folder/i7xwg4>Click here to check out my sendspace offerings! -=-=-=-=-=-=-=-=-=-=-=- -- JFW related links: JFW homepage: http://www.freedomscientific.com/ JFW List instructions: To post a message to the list, send it to [email protected] To unsubscribe from this mailing list, send a message to [email protected] Archives located at: http://www.groups.io/g/jfw/threads Alternative archives located at: http://n2.nabble.com/JAWS-for-Windows-f2145279.html If you have any concerns about the list, posts received from the list, or the way the list is being run, do not post them to the list. Rather contact the list owner at [email protected]. -=-=- Groups.io Links: You receive all messages sent to this group. View This Message (#36227): https://groups.io/g/jfw/message/36227 Mute This Thread: https://groups.io/mt/362489?uid=21656 Change Your Subscription: https://groups.io/g/jfw/editsub?uid=21656 Unsubscribe: https://groups.io/g/jfw/leave/46502/1292106160/xyzzy Group Home: https://groups.io/g/jfw Contact Group Owner: [email protected] Terms of Service: https://groups.io/static/tos -=-=-=-=-=-=-=-=-=-=-=-
