Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how format date with TEXT() function for international usage? | Excel Worksheet Functions | |||
Date Conversion | Excel Discussion (Misc queries) | |||
Date Conversion | Excel Discussion (Misc queries) | |||
Losing date values upon conversion from EXCEL to CSV | Excel Discussion (Misc queries) | |||
date conversion | Excel Worksheet Functions |