• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

(RT) - VBA to convert the range B in number format??

Rohit Tiwari

New Member
Hi All,

I need a help where I have the numbers in column B but they are not in the number format. So I want the moment my macro paste the data in column B, it should convert that column in number format. I have tried multiple time but it only paste the data in as usual format.

Kindly advise
 
Rohit, do you have the macro and using it for the copy paste OR you need the syntax for one?
Also probably did you try to change the format of the column?
 
Back
Top