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
<tbody>
</tbody>
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
A | B |
Date | Amt |
25-03-17 | 500 |
15-02-17 | 6985 |
20-03-17 | 84 |
12-01-17 | 7321 |
<tbody>
</tbody>