I have a number of budget pages which have been laid out as 000's. ie. if the
budget displays 100 then the figure should be read as 100,000. If the figure
is .5 then it should be read as 500.

what I want to do is change this to show the full value. I thought there was
an option in paste special to multiply each number being pasted by a given
number. However, I can't find this option.

Any suggestions would be appreciated.