I have create a table and insert data from an array to that table.How do I change the format of certain column to Percent?(not manually)

Execute ("CREATE TABLE Tablename (Name Char,Total Integer,Percent Number)")

For i = 1 To 100
Execute ("INSERT INTO Tablename Values ('" & name(i) & "','" & total(i) & " ',' " & perc(I) & " ')")
Next i

how can i change the 3rd column format to percent?