Macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Still learning@work - 29 May 2008 17:54 GMT

I am importing information from an AS400 to an Excel spreadsheet. The date
imports as 20080528. Is it possible to write a macro that will insert the
date markers (/) at set intervals?

I have never written a macro but do understand the theory behind them. Any
help would be appreciate.

Reply to this Message

JW - 29 May 2008 18:19 GMT

On May 29, 12:54 pm, Still learning@work
<Stilllearningw...@discussions.microsoft.com> wrote:

> I am importing information from an AS400 to an Excel spreadsheet. The date
> imports as 20080528. Is it possible to write a macro that will insert the
> date markers (/) at set intervals?
>
> I have never written a macro but do understand the theory behind them. Any
> help would be appreciate.

If you are wanting to do this after the import, I would just use a
formula instead of a macro.
There are a few different ways to do this, but assuming 20080528 is in
E2.
=LEFT(E2,4) &"/" & MID(E2,5,2) & "/" & RIGHT(E2,2)

Reply to this Message

Still learning@work - 29 May 2008 19:17 GMT

How do I apply this formula to convert the entire column?

> On May 29, 12:54 pm, Still learning@work
> <Stilllearningw...@discussions.microsoft.com> wrote:
[quoted text clipped - 10 lines]
> E2.
> =LEFT(E2,4) &"/" & MID(E2,5,2) & "/" & RIGHT(E2,2)

Reply to this Message

JW - 29 May 2008 19:47 GMT

On May 29, 2:17 pm, Still learning@work
<Stilllearningw...@discussions.microsoft.com> wrote:

> How do I apply this formula to convert the entire column?
>
[quoted text clipped - 14 lines]
>
> - Show quoted text -

Just drag the formula down as far as needed. It's references will
automatically change.

Reply to this Message