Vba convert values to numbers and put currency in front of the values

Hello,

I am not able to convert values to numbers for the Columns A to F. Also i want to add currency $ in front of all the values and align them to center.

nofrmt.PNG

Below is the code :

Please Login or Register  to view this content.

Thank You!

Regards
Wither

Your numbers are formatted as text.

Go to the data tab on the excel ribbon.

Select column A.

On the ribbon, click Text to columns, then click finish.

Repeat for each column.

Now apply your formats as normal.

Hello jason,

can it be done through macro as i wouldn't need to do manually for n no of files.

Thanks xladept it works ! .

Also ,how to align the values in column A to F in center?