i'm trying to separate a column of 9 digit zip codes into 5 and 4. i've tried the data, text to columns option but the problem is zip codes that start with 0 - even when i format them, the text to columns application reads them as only 8 digits so they don't divide in the right place. suggestions?

thanks!