<VV> Excel time formats ? Lesson learned : Do not use Excel data in VV

Charles Lee at Proper Pro Per chaz at ProperProPer.com
Sat May 5 23:39:51 EDT 2007


Aahh !  Found out something about VV :

Here's the part that VV clipped out of my email (see the last example below) 
:

>       dddd mmmm dd, yyyy Saturday January 06, 2007
>       mm dd, yyyy 01/06/2007
>       ddd mmm dd, yy Sat Jan 06, 07
>       ddd mmm dd, yy \@ hh:mm:ss am/pm Sat Jan 06, 07 @ 04:59:59 PM
>
>       NOTE : Put a 'backslash' before any actual character you may want 
> (i.e. : \@)
>

This had been in Excel 'cells' and copied into my email.

Fortunately, and the reason that John didn't have a problem, is that I sent 
his 'offline' (not via VV) so his didn't lose the important bits !

I had thunk it might get 'unformatted' but it gets completely dumped instead 
!!!!

Lesson learned : Do not use Excel data in VV

Thanks for the uptake !
Chaz

----- Original Message ----- 
From: "J R Read_HML" <hmlinc at sbcglobal.net>
To: "Charles Lee at Proper Pro Per" <chaz at ProperProPer.com>
Sent: Saturday, May 05, 2007 2:52 PM
Subject: Re: <VV> Fw: Excel time formats ?


> You clock must run pretty slow.
>
> Later, JR
>
>
>
> m - for single digit months : Jan = 1
> mm - for double digit months : Jan = 01
> mmm - for 3-letter abbreviation mmmm - for full month name
> d, dd, ddd and dddd same as for months
>
> yy and yyyy for 2-digit and 4-digit years.
>
> Chaz
>
>
> 



More information about the VirtualVairs mailing list