View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ligaya Ligaya is offline
external usenet poster
 
Posts: 31
Default International Date Conversion to Values

Hello,

I have been trying to program in VB converting International dates to values.

2. The original dates are formatted as general with a blank character at the
beginning of the date " 01/06/2006". I got the VB running to eliminate the
blank character.

3. I got the vb running to convert the International date to English
06/01/2006. However ,the dates passed 12/06/2006 (e.g 13/06/2006) remains in
this format and also has a general format and does not convert to values..

Example of Dates

01/06/2006
10/06/2006
12/06/2006
13/06/2006
14/06/2006


Any help will be greatly appreciated.

Thanks.


Ligaya