| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
code to convert date from TEXT format (03-02) to DATE format (200203)
Hi there - i'm hoping to get assistance with converting the following date
format to: yyyymm using vba... the worksheet already contains some macros, so i would like to incorporate this formatting step into it... COLUMN A currently contains the following values in TEXT format: MM-YY 03-02 would like to convert to 200203 TOTAL 04-02 would like to convert to 200204 TOTAL 05-02 would like to convert to 200205 TOTAL FY-02 TOTAL 06-02 would like to convert to 200206 TOTAL 07-02 would like to convert to 200207 TOTAL and on in the similar fashion for approx. 1000 entries... i would like to convert the DATES to the following date format - yyyymm (example- 200203) any assistance, AS USUAL, is VERY appreciated! Tks! Sandi |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| from date format convert to text format is wrong | Excel Discussion (Misc queries) | |||
| How do I convert dd/mm/yy date format to yyddd Julian date format | Excel Worksheet Functions | |||
| Convert date from text format to date format | Excel Discussion (Misc queries) | |||
| Convert date + time text format to date format | Excel Worksheet Functions | |||
| Help: How do I convert a text date into a real date format | Excel Worksheet Functions | |||
![Gauthier[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
