You can also do this with Copy & PasteSpecial

In any cell on the worksheet, enter the number 0.01 and copy it

Then highlight the range of the numbers you want to change the format of and
select PasteSpecial and choose the MULTIPLY radio button under OPERATION.


"dcsawyers" wrote:

I'm importing a text file with a lot of numbers in the format of XXXXX and
want to format them as XXX.XX without having to divide all the numbers by 100
and then place in a separate column. Is there a way to create a custom
format that will do this for me?