Hi, I am trying to format some census tract data for a class project that has some cells that show up in the format "1234.56" but would like to remove the decimal and retain what was after it. the only manual way I can think of to do this would be to script text to columns to use the period as the separator, then send the decimal value to an arbitrary value that can just be recycled to hold the data and then maybe use an activecell & <arbitrary cell> to recall it. I'm stuck as to how to set the destination for the decimal data.

Thanks in advance for any tips you can offer.

p.s. i have to run out to take care of some things, so i appologize for any late replies.