Default date format

Yahoo Archive
1
I just select the column and change the format to only show date with no
time, then it hides the time segment in the display.


Paul Millsaps
Time Manufacturing
254.399.2170
paulm@... <mailto:paulm@...>

This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission.
If you receive this message in error, please immediately delete it and
all copies of it from your system, destroy any hard copies of it and
notify the sender. You must not, directly or indirectly, use, disclose,
distribute, print, or copy any part of this message if you are not the
intended recipient.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Kerry Travis
Sent: Wednesday, September 24, 2008 11:57 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Default date format



Good afternoon all,

Is there any way to change the default date format in Vantage to date
only? Everytime you copy and paste anything into Excel, you get the
time as well.

Thanks for your help.

Kerry Travis, CGA
Controller
International Name Plate Supplies Ltd.

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
2
Good afternoon all,

Is there any way to change the default date format in Vantage to date only? Everytime you copy and paste anything into Excel, you get the time as well.Â

Thanks for your help.


Kerry Travis, CGA
Controller
International Name Plate Supplies Ltd.

[Non-text portions of this message have been removed]
3
A quick fix to this would be use the text to column feature in excel and
split the time off the date and then just delete the time column.



~charlie



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Kerry Travis
Sent: Wednesday, September 24, 2008 12:57 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Default date format



Good afternoon all,

Is there any way to change the default date format in Vantage to date only?
Everytime you copy and paste anything into Excel, you get the time as well.


Thanks for your help.

Kerry Travis, CGA
Controller
International Name Plate Supplies Ltd.

[Non-text portions of this message have been removed]



No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.169 / Virus Database: 270.7.1/1686 - Release Date: 9/23/2008
7:38 AM




[Non-text portions of this message have been removed]
4
If you format the column as a date column before you do the paste then you will only see the date portion.

----- Original Message -----
From: Charlie Wilson
To: vantage@yahoogroups.com
Sent: Wednesday, September 24, 2008 12:11 PM
Subject: RE: [Vantage] Default date format


A quick fix to this would be use the text to column feature in excel and
split the time off the date and then just delete the time column.

~charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Kerry Travis
Sent: Wednesday, September 24, 2008 12:57 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Default date format

Good afternoon all,

Is there any way to change the default date format in Vantage to date only?
Everytime you copy and paste anything into Excel, you get the time as well.

Thanks for your help.

Kerry Travis, CGA
Controller
International Name Plate Supplies Ltd.

[Non-text portions of this message have been removed]

No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.169 / Virus Database: 270.7.1/1686 - Release Date: 9/23/2008
7:38 AM

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]