Good afternoon to all Other than creating new columns and doing a couple of =left and an =right and then adding a couple more columns to help with concatenating..... is there an easier way to change a date from 19991031 to 10/31/1999 I have almost 12,000 rows and a bunch of columns that I need to change.
Thank you in advance for any help!