<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