hey,

im making a timeline plan for school, and when i enter the date such a
3/2/06 it autocorrects it and changes it to 03/02/2006 which i dont hav
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 fac
that the grey lines between each cell dont get printed. so how do i ad
these lines so when i print it it comes out as a table, and can
customise these lines?

thanks for your help

--
FAJIT
-----------------------------------------------------------------------
FAJITA's Profile: http://www.excelforum.com/member.php...fo&userid=3640
View this thread: http://www.excelforum.com/showthread.php?threadid=56181

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" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> 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...o&userid=36403
> View this thread:
> http://www.excelforum.com/showthread...hreadid=561814
>

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 th
Sheet tab. There's a option to print sheet.

The other way is to outline the area with a border.

VBA Noo

--
VBA Noo
-----------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...fo&userid=3383
View this thread: http://www.excelforum.com/showthread.php?threadid=56181

thanks guys. it really helped.


--
FAJITA
------------------------------------------------------------------------
FAJITA's Profile: http://www.excelforum.com/member.php...o&userid=36403
View this thread: http://www.excelforum.com/showthread...hreadid=561814

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...o&userid=36403
View this thread: http://www.excelforum.com/showthread...hreadid=561814

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...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=561814

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...o&userid=36403
View this thread: http://www.excelforum.com/showthread...hreadid=561814

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
<(E-Mail Removed)> wrote:

>
> im sorry i didnt really understand that at all, but it doesnt matter, i
> figred out a way around it. thanks anyway
>
>



--
Steve (3)