Macro

  • Thread starter Thread starter Still learning@work
  • Start date Start date
S

Still learning@work

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.
 
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.
Click to expand...

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)
 
How do I apply this formula to convert the entire column?






- Show quoted text -
Click to expand...

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