2 questions - one about inserting the date, other about adding lines. FAJITA <FAJITA.2b124c_1153035303.9648[ at ]excelforum-nospam.com> 16.07.2006 07:30:12 hey, im making a timeline plan for school, and when i enter the date such as 3/2/06 it autocorrects it and changes it to 03/02/2006 which i dont have enough room for. is there a way so it doesnt automatically change it? and the other is ive already typed up my table, disregarding the fact that the grey lines between each cell dont get printed. so how do i add these lines so when i print it it comes out as a table, and can i customise these lines? thanks for your help. -- FAJITA ------------------------------------------------------------------------ FAJITA's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36403 View this thread: http://www.excelforum.com/showthread.php?threadid=561814

Re: 2 questions - one about inserting the date, other about adding lines. "Roger Govier" <roger[ at ]technologyNOSPAM4u.co.uk> 16.07.2006 07:58:45 Hi For the date format, then Format>Cells>Number>Custom and enter in the white pane d/m/yy if you mean 3 Feb 06, or m/d/yy if you mean 2 Mar 06 To get the borders to cells either File>Page Setup>Sheet> check Print Gridlines or Mark your range of data the Format>Cells>Border>choose border style -- Regards Roger Govier "FAJITA" <FAJITA.2b124c_1153035303.9648[ at ]excelforum-nospam.com> wrote in message news:FAJITA.2b124c_1153035303.9648[ at ]excelforum-nospam.com... [Quoted Text] > > hey, > > im making a timeline plan for school, and when i enter the date such > as > 3/2/06 it autocorrects it and changes it to 03/02/2006 which i dont > have > enough room for. is there a way so it doesnt automatically change it? > > and the other is ive already typed up my table, disregarding the fact > that the grey lines between each cell dont get printed. so how do i > add > these lines so when i print it it comes out as a table, and can i > customise these lines? > > thanks for your help. > > > -- > FAJITA > ------------------------------------------------------------------------ > FAJITA's Profile: > http://www.excelforum.com/member.php?action=getinfo&userid=36403 > View this thread: > http://www.excelforum.com/showthread.php?threadid=561814 >

Re: 2 questions - one about inserting the date, other about adding lines. VBA Noob <VBA.Noob.2b13a0_1153036804.3007[ at ]excelforum-nospam.com> 16.07.2006 07:59:10 Try formatting the cells with the date. Go format > Custom >DD/MM/YY The gridlines can be printed. Go to print preview. Setup and then the Sheet tab. There's a option to print sheet. The other way is to outline the area with a border. VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33833 View this thread: http://www.excelforum.com/showthread.php?threadid=561814

Re: 2 questions - one about inserting the date, other about adding lines. FAJITA <FAJITA.2b17od_1153042506.1879[ at ]excelforum-nospam.com> 16.07.2006 09:30:27 thanks guys. it really helped. -- FAJITA ------------------------------------------------------------------------ FAJITA's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36403 View this thread: http://www.excelforum.com/showthread.php?threadid=561814

Re: 2 questions - one about inserting the date, other about adding lines. FAJITA <FAJITA.2b18dd_1153043405.2543[ at ]excelforum-nospam.com> 16.07.2006 09:49:36 one more thing actually could u please have a look at the attachment is there anyway that i can have two symbols in the one box, one above the other if possible. thanks again +-------------------------------------------------------------------+ |Filename: sample.JPG | |Download: http://www.excelforum.com/attachment.php?postid=5037 | +-------------------------------------------------------------------+ -- FAJITA ------------------------------------------------------------------------ FAJITA's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36403 View this thread: http://www.excelforum.com/showthread.php?threadid=561814

Re: 2 questions - one about inserting the date, other about adding lines. VBA Noob <VBA.Noob.2b1age_1153046105.926[ at ]excelforum-nospam.com> 16.07.2006 10:34:11 Yes you can I opened up the Character Map and selected Wingdings2 and Selected a Dot and a X. I then added to excel change the cell style to Wingdings2. Then I wrapped the text to stack them VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33833 View this thread: http://www.excelforum.com/showthread.php?threadid=561814

Re: 2 questions - one about inserting the date, other about adding lines. FAJITA <FAJITA.2b1bud_1153047906.9737[ at ]excelforum-nospam.com> 16.07.2006 11:02:06 im sorry i didnt really understand that at all, but it doesnt matter, i figred out a way around it. thanks anyway -- FAJITA ------------------------------------------------------------------------ FAJITA's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36403 View this thread: http://www.excelforum.com/showthread.php?threadid=561814

Re: 2 questions - one about inserting the date, other about adding lines. SteveW <sj_walton[ at ]nothotmail.com> 16.07.2006 11:52:29 You an have the text configured to run vertically. charcters don't have to be of the same font, nor size. some can be bold = = italic etc Plenty of possibilites On Sun, 16 Jul 2006 12:02:06 +0100, FAJITA = <FAJITA.2b1bud_1153047906.9737[ at ]excelforum-nospam.com> wrote: [Quoted Text] > > im sorry i didnt really understand that at all, but it doesnt matter, = i > figred out a way around it. thanks anyway > > -- = Steve (3)