LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
jim jim is offline
external usenet poster
 
Posts: 2
Default macro to rearrange numbers in cell?

We have general office workers in our school district who use an
antiquated student information system to download roster information in
text format for import into Excel. A user recently asked me if there is
a way to globally change the outputted date format 20011028 to 10282001
after it has been imported. I'm thinking a macro would do it. Any ideas
would be greatly appreciated.

Thanks,

-Jim Epler
Grossmont Union High School District
El Cajon, CA
http://edtech.guhsd.net/

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
To remove numbers in a cell with out using the macro Vital_ar Excel Worksheet Functions 2 October 27th 09 01:45 PM
How can I rearrange worksheets? trishk Excel Worksheet Functions 2 August 20th 08 02:07 PM
How to rearrange data... Eric Charts and Charting in Excel 1 January 10th 07 10:31 PM
Rearrange numbers from a column in a different order in a second c Gaetan58 Excel Discussion (Misc queries) 14 November 21st 06 07:43 AM
Macro help to rearrange excel table Alan[_31_] Excel Programming 1 April 19th 06 10:05 PM


All times are GMT +1. The time now is 05:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"