Hello,

I have created a macro that basically cleans up a spread sheet into 2 columns. I need help formatting my second column. Here is my code

Sub TD_328_Mod()
'
' TD_328_Mod Macro
'
    Range("A:B,D:H,J:J").Select
    Range("J1").Activate
    Selection.Delete Shift:=xlToLeft
    Rows("1:2").Select
    Selection.Delete Shift:=xlUp
    Range("D9").Select
    [B1:B200] = [(B1:B200)*0.98]
    Columns(2).NumberFormat = "General"
Here is what the format result

A	0.010958258
B	0.008955046
C 	0.016297292
D	0.008695897
E	0.009998009
F	0.007550056
G	0.014971408
H	0.013469306
I	0.004525804
J	0.001593156
K	0.006495379
L	0.0078487
M	0.011974934
N	0.009942814
I am looking for the correct code to format Column B so that the number is * by 100 and rounded to two decimal places

For example A = 1.10 and B= .90

Thank You for your help