Percent format in Excel

I often import data that does not have percentages in the correct numerical format, i.e. 25.00 for 25% instead of .2500

Is there a way to have Excel recognize that is is meant to be a percentage, and add the % sign, without having to add columns to divide by 100??