I have a dollar amount that is being retrived via Vlookup. It contains a decimal. The amount is not more than 9999.99. I need to insert it into a text string with the format of 000000 where the last two positions are the cents (probably obvious but want to be explicit here...). I cannot get it to work - tried creating new intermediate column and different formats for that etc.