|
PureBytes Links
Trading Reference Links
|
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
>
>[Non-text portions of this message have been removed]
>
>
>
------------------------ 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/
|