Hi Pavan,
two suggestions
option 1- create an extra column in your excel which maps to the one with the VB script code.
In Serv Studio read this new column instead of the other one
option 2-Regardless doing a vb script code in excel file to calculate a value, why not apply that rule for that column while reading the data in Serv Studio
Hope that it helps