[EquisMetaStock Group] Re: Changing existing date format (Excel files)

[<ckng001@xxxxxxxxxxxx>]

Dear Ron,

Thank you for reply.  The excel files aren't obtained by conversion with
downloader.  They are key-in manually for reference purpose, eg. warrants
info with their respective expiry date and conversion price.  By default
when dates are key-in manually, it's interpreted along the US date format by
excel (since the default regional setting in control panel is just that).
They will be wrong if they are key-in as d/m/yyyy in a default m/dd/yyyy
setting, in the first place.

(The downloader (ver 8.0) could export (convert) files to excel - the dates
come in mm/dd/yyyy (general format) irrespective of the regional setting.
To adjust the excel data, for eg, sort in descending order - the date
columns is first reformatted to date (from general)).

Best regards,

>
> Message: 8
>    Date: Thu, 16 Mar 2006 08:40:05 -0500
>    From: "Ron Berlin" <rsb_44@xxxxxxxxxxx>
> Subject: RE: Re: Changing existing date format (Excel files)
>
> Are you certain what appears as dates in excel are in fact numeric values
> that can be formatted as dates, or are they text strings? When the
> Downloader exports a file into Excel format the date is a text string and
> can't be changed with date formatting. You need to use datevalue function
to
> convert the text string to a number and then you can format the number to
> whateevr date format you want:
>
> =datevalue(03/06/2006)  gets 38782;  the 38782 can be turned into any date
> format you want.
>
>
> >From: <ckng001@xxxxxxxxxxxx>
> >Reply-To: equismetastock@xxxxxxxxxxxxxxx
> >To: <equismetastock@xxxxxxxxxxxxxxx>
> >Subject: [EquisMetaStock Group] Re: Changing existing date format (Excel
> >files)
> >Date: Thu, 16 Mar 2006 12:45:41 +0800
> >
> >Dear all,
> >
> >In my Excel files, my expiry date, date of change, date of listing are
> >found to be in the default US format ie. m/d/yyyy.  The dates key-in are
> >supposed to be in d/m/yyyy (UK format).  For eg, 5/1/2006
(5-January-2006)
> >previously key-in, is found to be 1-May-2006.  Re-formatting the cells to
> >UK date format did not help.  Neither do changing the regional setting in
> >control panel.  Manually inter-changing the day and month is mad.  Maybe
> >there is some way to automate the inter-changing process for these
previous
> >dates.
> >
> >Thank you.
> >
> >Best regards,
> >ckng
> >





------------------------ Yahoo! Groups Sponsor --------------------~--> 
Try Online Currency Trading with GFT. Free 50K Demo. Trade 
24 Hours. Commission-Free. 
http://us.click.yahoo.com/RvFikB/9M2KAA/U1CZAA/BefplB/TM
--------------------------------------------------------------------~-> 

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/equismetastock/

<*> To unsubscribe from this group, send an email to:
    equismetastock-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/