I have a requirement to import data in to Excel. The data has a number with an two implied decimal places. Is there a way to 'automatically' insert a decimal point just to the left of the two rightmost digits ?

Example input 1234. Would like to convert to 12.34 via the import or a macro for an entire column.

Thanks much in advance.

Thurman