Date column Numbers Changes To Lines

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

highbids - 03 Jan 2006 10:36 GMT

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 & keep the lines
from showing up & keep just the date.

Gary

Reply to this Message

Niek Otten - 03 Jan 2006 12:35 GMT

Format the cells as Date, choose one of the example dates.

Signature

Kind regards,

Niek Otten

> Hi,
>
[quoted text clipped - 5 lines]
>
> Gary,

Reply to this Message

highbids - 03 Jan 2006 13:05 GMT

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,

Signature

highbids

Reply to this Message