Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro
On May 29, 12:54*pm, Still learning@work
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) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro
How do I apply this formula to convert the entire column?
"JW" wrote: On May 29, 12:54 pm, Still learning@work 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) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro
On May 29, 2:17*pm, Still learning@work
wrote: How do I apply this formula to convert the entire column? "JW" wrote: On May 29, 12:54 pm, Still learning@work 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)- Hide quoted text - - Show quoted text - Just drag the formula down as far as needed. It's references will automatically change. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoRun Macro with a delay to give user the choice to cancel the macro | Excel Programming | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Macro not showing in Tools/Macro/Macros yet show up when I goto VBA editor | Excel Programming | |||
Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |