Append .00 to a number

**sysadmin** · 03-07-2011, 10:12 AM

Hi Guys,

i'm trying to find a VBA script that will run on a selected column and add .00 to the end of a number in the cells that are populated.

i.e

0 would become 0.00 or 48 would become 48.00,

i have tried using the cell format but that doesnt work once the file has been exported to a csv using a macro as it is Excel formatting not the actual data that is changed.

thanks in advance

**arthurbr** · 03-07-2011, 10:20 AM

Maybe a helper column containing =A1&".00" ?

**sysadmin** · 03-07-2011, 10:40 AM

thanks arthurbr that does work but then i need the macro to move the values from the helper column and replace the existing column as it needs to be in a specific order for the csv export is there a way to do that with a macro or is there a macro version of the helper column?

regards