software

Hi,

I have excel 2003 and when I try and slide the date column over
to get ride of the seconds in it, I get garbled lines.

How can I slide it over to get ride of the seconds amp; keep the lines
from showing up amp; keep just the date.

Gary,--
highbids
------------------------------------------------------------------------
highbids's Profile: www.excelforum.com/member.php...oamp;userid=30073
View this thread: www.excelforum.com/showthread...hreadid=497511Format the cells as Date, choose one of the example dates.

--
Kind regards,

Niek Otten

quot;highbidsquot; gt; wrote in
message ...
gt;
gt; Hi,
gt;
gt; I have excel 2003 and when I try and slide the date column over
gt; to get ride of the seconds in it, I get garbled lines.
gt;
gt; How can I slide it over to get ride of the seconds amp; keep the lines
gt; from showing up amp; keep just the date.
gt;
gt; Gary,
gt;
gt;
gt; --
gt; highbids
gt; ------------------------------------------------------------------------
gt; highbids's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30073
gt; View this thread: www.excelforum.com/showthread...hreadid=497511
gt;

It worked, but now it shows everything in 2006.

80% of the spreadsheet was created in 2005 and about 20% was
created in 2006 Whats the easy way to change them.

Also I have other spreadsheets that where created the same way.

But I haven't done anything with the date yet.

Gary,--
highbids
------------------------------------------------------------------------
highbids's Profile: www.excelforum.com/member.php...oamp;userid=30073
View this thread: www.excelforum.com/showthread...hreadid=497511