Need VBA to Insert column in K:K and convert date as MMM-DD from J:J

**breadwinner** · 08-14-2016, 03:53 PM

Dear expert

I have data which contains report of retail revenues i have date format in J:J which downloaded format as Jan2015 i want convert it as Jan-15 in K:K column

i want insert new column and convert date as Jan-15 from J:J

please find the attachment

**LeoTaxi** · 08-14-2016, 04:59 PM

This will do

Please Login or Register  to view this content.

Kind regards
Leo

**Norie** · 08-14-2016, 05:08 PM

Try this.

Please Login or Register  to view this content.

**sanram** · 08-14-2016, 05:22 PM

Use this :

Please Login or Register  to view this content.

**breadwinner** · 08-17-2016, 10:25 AM

Thanks Experts Solved 100%

Need VBA to Insert column in K:K and convert date as MMM-DD from J:J

LinkBack

Thread Tools

Rate This Thread

Display

Need VBA to Insert column in K:K and convert date as MMM-DD from J:J

Re: Need VBA to Insert column in K:K and convert date as MMM-DD from J:J

Re: Need VBA to Insert column in K:K and convert date as MMM-DD from J:J

Re: Need VBA to Insert column in K:K and convert date as MMM-DD from J:J

Re: Need VBA to Insert column in K:K and convert date as MMM-DD from J:J

Thread Information

Users Browsing this Thread

Similar Threads

Find most recent date in Column Headings in a Range, insert new column and heading

[SOLVED] How do I convert column of dates into column of date values?

Convert String to Date in Column

How can I insert date of today in column C when I enter data in column B?

Insert Date & Time to a neightbouring column when I double click in column A

convert date column to general value

Convert Column to Date Format

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions