Again I have to rely on this forum for I am stumped. I have a column with Roman numerals created with the "Roman" worksheet formula. When I run my macro, it works but all the numbers come up as zeros. If I type the Roman numeral in the cells manually, it will work with the join/transpose formula combination perfectly. Is there a way around not having to manually type in each Roman numeral number. I have tried both worksheet formulas and VBA code to no avail. Has anyone else ran up against this and if so is there a fix for this. Thanks again to all the help I have received in the past.