|
PureBytes Links
Trading Reference Links
|
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/
|